From: Stefan Huchler <stefan.huchler@mail.de>
To: emacs-orgmode@gnu.org
Subject: Re: Tables: remote reference fails with umlaut (and in other cases)
Date: Tue, 19 Jan 2016 23:28:50 +0100 [thread overview]
Message-ID: <871t9d2ogt.fsf@jupiter.lan> (raw)
In-Reply-To: 877fj55xqs.fsf@alphaville.usersys.redhat.com
Nick Dokos <ndokos@gmail.com> writes:
> Eric S Fraga <e.fraga@ucl.ac.uk> writes:
>
> You are missing a quote:
>
> #+TBLFM: $1='(identity remote(2016-01-19-srctbl,@@#$1))
>
> works for me.
>
> Org-mode version 8.3.3 (release_8.3.3-456-g164555)
>
> --
> Nick
Wow,
that was an eye opener for me, first it lets me use/refer to german
umlauts, second I can use by this method full power of elisp on the
data:
#+TBLFM: $3='(nth 1 (split-string remote(addresstable, @@#$6) "@"))
extracts the hostname from a mail adress foo@bar.com -> bar.com.
it maybe makes even some kind of table data joining possible, failed
there on a tea-shopping database I tried to do in the past.
so thanks.
next prev parent reply other threads:[~2016-01-19 22:30 UTC|newest]
Thread overview: 10+ messages / expand[flat|nested] mbox.gz Atom feed top
2016-01-19 13:10 Tables: remote reference fails with umlaut (and in other cases) Karl Voit
2016-01-19 15:12 ` Eric S Fraga
2016-01-19 15:29 ` Karl Voit
2016-01-19 19:04 ` Michael Brand
2016-01-25 14:48 ` Karl Voit
2016-01-25 17:57 ` Michael Brand
2016-01-19 16:40 ` Nick Dokos
2016-01-19 22:28 ` Stefan Huchler [this message]
2016-01-20 12:01 ` Karl Voit
2016-01-19 16:32 ` Stefan Huchler
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
Avoid top-posting and favor interleaved quoting:
https://en.wikipedia.org/wiki/Posting_style#Interleaved_style
List information: https://www.orgmode.org/
* Reply using the --to, --cc, and --in-reply-to
switches of git-send-email(1):
git send-email \
--in-reply-to=871t9d2ogt.fsf@jupiter.lan \
--to=stefan.huchler@mail.de \
--cc=emacs-orgmode@gnu.org \
/path/to/YOUR_REPLY
https://kernel.org/pub/software/scm/git/docs/git-send-email.html
* If your mail client supports setting the In-Reply-To header
via mailto: links, try the mailto: link
Be sure your reply has a Subject: header at the top and a blank line
before the message body.
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).