From mboxrd@z Thu Jan  1 00:00:00 1970
From: Eric Schulte <schulte.eric@gmail.com>
Subject: Re: sqlite im-/export
Date: Thu, 16 May 2013 14:48:50 -0600
Message-ID: <87sj1mlkgd.fsf@gmail.com>
References: <87r4h6dfa9.fsf@kerstf.org> <87zjvuloz3.fsf@gmail.com>
	<87ip2id75m.fsf@kerstf.org>
Mime-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: quoted-printable
Return-path: <emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org>
Received: from eggs.gnu.org ([208.118.235.92]:55706)
	by lists.gnu.org with esmtp (Exim 4.71)
	(envelope-from <schulte.eric@gmail.com>) id 1Ud570-0002Ud-Fw
	for emacs-orgmode@gnu.org; Thu, 16 May 2013 16:49:24 -0400
Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71)
	(envelope-from <schulte.eric@gmail.com>) id 1Ud56v-0002BS-CZ
	for emacs-orgmode@gnu.org; Thu, 16 May 2013 16:49:18 -0400
Received: from mail-pa0-f45.google.com ([209.85.220.45]:63539)
	by eggs.gnu.org with esmtp (Exim 4.71)
	(envelope-from <schulte.eric@gmail.com>) id 1Ud56v-0002BO-6F
	for emacs-orgmode@gnu.org; Thu, 16 May 2013 16:49:13 -0400
Received: by mail-pa0-f45.google.com with SMTP id lj1so2885754pab.32
	for <emacs-orgmode@gnu.org>; Thu, 16 May 2013 13:49:12 -0700 (PDT)
In-Reply-To: <87ip2id75m.fsf@kerstf.org> ("Oliver =?utf-8?B?VmXEjWVybsOt?=
	=?utf-8?B?ayIncw==?= message of "Thu, 16 May 2013 22:03:17 +0200")
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: Oliver =?utf-8?B?VmXEjWVybsOtaw==?= <ov@vecernik.at>
Cc: emacs-orgmode@gnu.org

Oliver Ve=C4=8Dern=C3=ADk <ov@vecernik.at> writes:

> Eric Schulte <schulte.eric@gmail.com> writes:
>> What about
>>
>> #+BEGIN_SRC sqlite :csv :db test.sqlite
>>   SELECT * from t1;
>> #+END_SRC
>>
>> #+RESULTS:
>> | 1 | apple pie |
>> | 2 | sugar     |
>
> I needed some calculations and format tweaking with awk which I piped
> the results.  That is why I choose the shell.  In this case this is not
> possible.

In that case I'd suggest either

1. adding :separator support to ob-sh.el, so that you can specify a
   different results separator to be passed to
   `org-babel-import-elisp-from-file'

or

2. use ":results drawer", and explicitly formatting the results in
   Org-mode syntax w/awk

Cheers,

--=20
Eric Schulte
http://cs.unm.edu/~eschulte