Re: [O] Concatenation of cells using 'remote'

[Michael Brand]

Hi Loris

On Fri, Jan 29, 2016 at 2:20 PM, Loris Bennett
<loris.benn...@fu-berlin.de> wrote:
> Hi,
>
> I can create a concatenation of the element in column like this:
>
> #+NAME: addresses
> | able    | a...@example.org                                         |
> | baker   | ba...@example.org                                        |
> | charlie | char...@example.org                                      |
> |         | a...@example.org, ba...@example.org, char...@example.org |
> #+TBLFM: $2='(concat $1 "@example.org")
> #+TBLFM: @4$2='(mapconcat 'identity (list @1$2..@3$2) ", ")
>
> I tried the following to create the concatenation in a
> separate table:
>
> | #ERROR |
> #+TBLFM: $1='(mapconcat 'identity '(list remote(addresses,@1$2..@3$2) ", ")
>
> but this doesn't work.  Presumably the expansion of the range happens at
> the wrong time.
>
> Does anyone know how to do this properly?

Just typos:

| a...@example.org, ba...@example.org, char...@example.org |
#+TBLFM: $1='(mapconcat 'identity (list remote(addresses,@1$2..@3$2)) ", ")

Michael