From mboxrd@z Thu Jan  1 00:00:00 1970
From: Achim Gratz <Stromeko@nexgo.de>
Subject: Re: [babel] Sh problem when echo'ing input data with ' inside
Date: Mon, 17 Jan 2011 22:36:11 +0100
Message-ID: <87fwsrusac.fsf@Rainer.invalid>
References: <80k4i3vgzo.fsf@missioncriticalit.com>
	<87k4i3uwpm.fsf@Rainer.invalid>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Return-path: <emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org>
Received: from [140.186.70.92] (port=50291 helo=eggs.gnu.org)
	by lists.gnu.org with esmtp (Exim 4.43) id 1PewkX-0004Nl-F9
	for emacs-orgmode@gnu.org; Mon, 17 Jan 2011 16:36:30 -0500
Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71)
	(envelope-from <geo-emacs-orgmode@m.gmane.org>) id 1PewkV-0005YA-U8
	for emacs-orgmode@gnu.org; Mon, 17 Jan 2011 16:36:29 -0500
Received: from lo.gmane.org ([80.91.229.12]:36764)
	by eggs.gnu.org with esmtp (Exim 4.71)
	(envelope-from <geo-emacs-orgmode@m.gmane.org>) id 1PewkV-0005Y2-7e
	for emacs-orgmode@gnu.org; Mon, 17 Jan 2011 16:36:27 -0500
Received: from list by lo.gmane.org with local (Exim 4.69)
	(envelope-from <geo-emacs-orgmode@m.gmane.org>) id 1PewkU-0002Ob-FZ
	for emacs-orgmode@gnu.org; Mon, 17 Jan 2011 22:36:26 +0100
Received: from p57aaca5a.dip.t-dialin.net ([87.170.202.90])
	by main.gmane.org with esmtp (Gmexim 0.1 (Debian))
	id 1AlnuQ-0007hv-00
	for <emacs-orgmode@gnu.org>; Mon, 17 Jan 2011 22:36:26 +0100
Received: from Stromeko by p57aaca5a.dip.t-dialin.net with local (Gmexim 0.1
	(Debian)) id 1AlnuQ-0007hv-00
	for <emacs-orgmode@gnu.org>; Mon, 17 Jan 2011 22:36:26 +0100
List-Id: "General discussions about Org-mode." <emacs-orgmode.gnu.org>
List-Unsubscribe: <http://lists.gnu.org/mailman/listinfo/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: <http://lists.gnu.org/mailman/listinfo/emacs-orgmode>,
	<mailto:emacs-orgmode-request@gnu.org?subject=subscribe>
Sender: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org
Errors-To: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org
To: emacs-orgmode@gnu.org

Achim Gratz <Stromeko@nexgo.de> writes:
> #+begin_src sh :var data=excel-from-bank :results output
> echo <<EOF | cmd1 | cmd2
> $data
> EOF
> #+end_src

Sent too soon: use cat, not echo.  Actually that is redundant, too:

#+begin_src sh :var data=excel-from-bank :results output
cmd1 <<EOF | cmd2
$data
EOF
#+end_src

Or even simpler (but that might be a bashism...):

#+begin_src sh :var data=excel-from-bank :results output
cmd1 <<<"$data" | cmd2
#+end_src

And I missed the preview in Erics post, which gave me the clue I was
looking for; the script produced by babel should actually look like
this:

#+begin_src sh
data=$(cat <<'BABEL_STRING'
Num.ro du compte :;979-9500975-24;Compte Maxi
Date valeur;R.f.rence de l'op.ration;Description;Montant de l'op.ration;Devise;Date d'op.ration;Compte de contrepartie;Nom de la contrepartie :;Communication 1 :;Communication 2 :
04-06-2009;A9F04NT01WK300TG;Virem. internet;420,00;EUR;04-06-2009;799-5900947-23;PAYEE ONE; ; 
24-02-2009;A9B24NT012K4018Z;Virem. internet;-54,93;EUR;24-02-2009;799-9974005-30;ME;Eigen rekening; 
18-05-2008;A8E19NT000S604QI;Virem. internet;-1.000,00;EUR;19-05-2008;799-8068445-18;PAYEE TWO; ;
BABEL_STRING
)
echo "$data"
#+end_src

That is no indentation and the here-tag should be in quotes (otherwise the
here-script is subject to shell expansion).  It's probably possible to
do a contrived redirection and not use a variable to store the data, but
I'm afraid I won't grok this today.


Achim.
-- 
+<[Q+ Matrix-12 WAVE#46+305 Neuron microQkb Andromeda XTk Blofeld]>+

Wavetables for the Terratec KOMPLEXER:
http://Synth.Stromeko.net/Downloads.html#KomplexerWaves