* Concatenation of cells using 'remote'
@ 2016-01-29 13:20 Loris Bennett
2016-02-15 17:42 ` Michael Brand
0 siblings, 1 reply; 3+ messages in thread
From: Loris Bennett @ 2016-01-29 13:20 UTC (permalink / raw)
To: emacs-orgmode
Hi,
I can create a concatenation of the element in column like this:
#+NAME: addresses
| able | able@example.org |
| baker | baker@example.org |
| charlie | charlie@example.org |
| | able@example.org, baker@example.org, charlie@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?
Cheers,
Loris
--
This signature is currently under construction.
^ permalink raw reply [flat|nested] 3+ messages in thread
* Re: Concatenation of cells using 'remote'
2016-01-29 13:20 Concatenation of cells using 'remote' Loris Bennett
@ 2016-02-15 17:42 ` Michael Brand
2016-02-16 7:32 ` Loris Bennett
0 siblings, 1 reply; 3+ messages in thread
From: Michael Brand @ 2016-02-15 17:42 UTC (permalink / raw)
To: Loris Bennett; +Cc: Org Mode
Hi Loris
On Fri, Jan 29, 2016 at 2:20 PM, Loris Bennett
<loris.bennett@fu-berlin.de> wrote:
> Hi,
>
> I can create a concatenation of the element in column like this:
>
> #+NAME: addresses
> | able | able@example.org |
> | baker | baker@example.org |
> | charlie | charlie@example.org |
> | | able@example.org, baker@example.org, charlie@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:
| able@example.org, baker@example.org, charlie@example.org |
#+TBLFM: $1='(mapconcat 'identity (list remote(addresses,@1$2..@3$2)) ", ")
Michael
^ permalink raw reply [flat|nested] 3+ messages in thread
* Re: Concatenation of cells using 'remote'
2016-02-15 17:42 ` Michael Brand
@ 2016-02-16 7:32 ` Loris Bennett
0 siblings, 0 replies; 3+ messages in thread
From: Loris Bennett @ 2016-02-16 7:32 UTC (permalink / raw)
To: emacs-orgmode
Michael Brand <michael.ch.brand@gmail.com> writes:
> Hi Loris
>
> On Fri, Jan 29, 2016 at 2:20 PM, Loris Bennett
> <loris.bennett@fu-berlin.de> wrote:
>> Hi,
>>
>> I can create a concatenation of the element in column like this:
>>
>> #+NAME: addresses
>> | able | able@example.org |
>> | baker | baker@example.org |
>> | charlie | charlie@example.org |
>> | | able@example.org, baker@example.org, charlie@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:
>
> | able@example.org, baker@example.org, charlie@example.org |
> #+TBLFM: $1='(mapconcat 'identity (list remote(addresses,@1$2..@3$2)) ", ")
>
> Michael
Thanks. Obviously I shouldn't be highlighting matching parens, but
rather ones which don't match ...
Cheers,
Loris
--
Dr. Loris Bennett (Mr.)
ZEDAT, Freie Universität Berlin Email loris.bennett@fu-berlin.de
^ permalink raw reply [flat|nested] 3+ messages in thread
end of thread, other threads:[~2016-02-16 7:33 UTC | newest]
Thread overview: 3+ messages (download: mbox.gz follow: Atom feed
-- links below jump to the message on this page --
2016-01-29 13:20 Concatenation of cells using 'remote' Loris Bennett
2016-02-15 17:42 ` Michael Brand
2016-02-16 7:32 ` Loris Bennett
Code repositories for project(s) associated with this public inbox
https://git.savannah.gnu.org/cgit/emacs/org-mode.git
This is a public inbox, see mirroring instructions
for how to clone and mirror all data and code used for this inbox;
as well as URLs for read-only IMAP folder(s) and NNTP newsgroup(s).