Re: [O] sqlite im-/export

[Eric Schulte]

Oliver Večerník <address@hidden> writes:

> Eric Schulte <address@hidden> 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,

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