From mboxrd@z Thu Jan  1 00:00:00 1970
From: Stefan Huchler <stefan.huchler@mail.de>
Subject: Re: Tables: remote reference fails with umlaut (and in other cases)
Date: Tue, 19 Jan 2016 23:28:50 +0100
Message-ID: <871t9d2ogt.fsf@jupiter.lan>
References: <2016-01-19T14-08-22@devnull.Karl-Voit.at>
	<877fj5eh8f.fsf@delle7240.chemeng.ucl.ac.uk>
	<877fj55xqs.fsf@alphaville.usersys.redhat.com>
Mime-Version: 1.0
Content-Type: text/plain
Return-path: <emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org>
Received: from eggs.gnu.org ([2001:4830:134:3::10]:47942)
	by lists.gnu.org with esmtp (Exim 4.71)
	(envelope-from <geo-emacs-orgmode@m.gmane.org>) id 1aLenF-0006HU-07
	for emacs-orgmode@gnu.org; Tue, 19 Jan 2016 17:30:29 -0500
Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71)
	(envelope-from <geo-emacs-orgmode@m.gmane.org>) id 1aLenB-00027E-OD
	for emacs-orgmode@gnu.org; Tue, 19 Jan 2016 17:30:28 -0500
Received: from plane.gmane.org ([80.91.229.3]:51739)
	by eggs.gnu.org with esmtp (Exim 4.71)
	(envelope-from <geo-emacs-orgmode@m.gmane.org>) id 1aLelp-0001iF-OU
	for emacs-orgmode@gnu.org; Tue, 19 Jan 2016 17:30:25 -0500
Received: from list by plane.gmane.org with local (Exim 4.69)
	(envelope-from <geo-emacs-orgmode@m.gmane.org>) id 1aLelk-0006it-Hv
	for emacs-orgmode@gnu.org; Tue, 19 Jan 2016 23:28:57 +0100
Received: from hsi-kbw-149-172-254-111.hsi13.kabel-badenwuerttemberg.de
	([149.172.254.111])
	by main.gmane.org with esmtp (Gmexim 0.1 (Debian))
	id 1AlnuQ-0007hv-00
	for <emacs-orgmode@gnu.org>; Tue, 19 Jan 2016 23:28:56 +0100
Received: from stefan.huchler by
	hsi-kbw-149-172-254-111.hsi13.kabel-badenwuerttemberg.de with
	local (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00
	for <emacs-orgmode@gnu.org>; Tue, 19 Jan 2016 23:28:56 +0100
List-Id: "General discussions about Org-mode." <emacs-orgmode.gnu.org>
List-Unsubscribe: <https://lists.gnu.org/mailman/options/emacs-orgmode>,
	<mailto:emacs-orgmode-request@gnu.org?subject=unsubscribe>
List-Archive: <http://lists.gnu.org/archive/html/emacs-orgmode>
List-Post: <mailto:emacs-orgmode@gnu.org>
List-Help: <mailto:emacs-orgmode-request@gnu.org?subject=help>
List-Subscribe: <https://lists.gnu.org/mailman/listinfo/emacs-orgmode>,
	<mailto:emacs-orgmode-request@gnu.org?subject=subscribe>
Errors-To: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org
Sender: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org
To: emacs-orgmode@gnu.org

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.