From mboxrd@z Thu Jan 1 00:00:00 1970 From: =?utf-8?Q?S=C3=A9bastien_Vauban?= Subject: Re: Org-Babel and Ledger Date: Fri, 13 Aug 2010 21:04:12 +0200 Message-ID: <871va2xrkj.fsf@mundaneum.com> References: <87eiemsk0m.fsf@mundaneum.com> <87fwz2b634.fsf@pellet.net> <87tyng66ja.fsf@gmail.com> <87vd7gyrz6.fsf@mundaneum.com> <871va3v3qk.fsf@gmail.com> <87zkwqzx0p.fsf@mundaneum.com> <87fwyizr0f.fsf@mundaneum.com> <87iq3ewgtw.fsf@gmail.com> Mime-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable Return-path: List-Id: "General discussions about Org-mode." List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Sender: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org-mXXj517/zsQ@public.gmane.org Errors-To: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org-mXXj517/zsQ@public.gmane.org To: emacs-orgmode-mXXj517/zsQ@public.gmane.org Hi Eric, "Eric Schulte" wrote: > S=C3=A9bastien Vauban writes: >> S=C3=A9bastien Vauban wrote: >>> "Eric Schulte" wrote: >>>> S=C3=A9bastien Vauban writes: >>>>> >>>>>>>> As you can see, the tables are completely wrongly made, because >>>>>>>> they're based on spaces ("=C3=A0 la Awk") and not on fixed positio= n of >>>>>>>> fields ("=C3=A0 la Cut"). >>>>>>>> >>>>>>>> What can I do about this? >>>>>>>> >>>>>>>> - Post-process every ledger command with some awk or cut command t= hat >>>>>>>> will do whatever is needed > > This might actually be a good solution for the shell block you mention > below. > >>>>>> >>>>>> (org-table-convert-region (point-min) (point-max)) >> >> As you adviced, I can play with the optional parameter in ob-ledger's co= de. >> >> But what about the results of sh code? >> >> Imagine now that I'm forced to use =3Dsh=3D instead of =3Dledger=3D, in = the >> following pratical case: >> >> #+srcname: reg >> #+begin_src sh >> m4 scorpios-ledger.dat | ledger -f - reg unknown >> #+end_src >> >> I'm using =3Dm4=3D (and thus make some pre-processing) because I need (o= r want) >> to be able to switch between =3Dledger=3D and =3Dhledger=3D and comment = in or out >> the directives that are accepted by one but not by the other. >> >> Then, such a result is still problematic: >> >> 09-Aug-21 CHEQUE : 9953055 Expenses:Unknown = 166.70 EUR 166.70 EUR >> 09-Sep-17 CHEQUE : 7691785 Expenses:Unknown = 100.00 EUR 266.70 EUR >> 09-Oct-16 REMISE CHEQUE N 8686318 001 105 Expenses:Unknown = -525.00 EUR -258.30 EUR >> >> I've looked in =3Dorg-babel-execute:sh=3D and =3Dorg-babel-reassemble-ta= ble=3D, >> among others, to look for similar constructs (calls to >> =3Dorg-table-convert-region=3D) but did not find any. >> >> Is there still a solution to get such results? > > As an interim solution you could add a :results scalar header argument to > your sh code block, then pass the output of that code block to a parsing > code block (namely the one from my previous email). That's certainly not > idea, but it should work for the moment. > > Alternately if ledger supports a more clearly delimited output format (e.= g. > csv) then that would probably work as well. > >> #+results: >> | 09-Aug-21 CHEQUE : 9953055 | Expenses:Unknown | 166.70 = EUR | 166.70 EUR | >> | 09-Sep-17 CHEQUE : 7691785 | Expenses:Unknown | 100.00 = EUR | 266.70 EUR | >> | 09-Oct-16 REMISE CHEQUE N 8686318 001 105 | Expenses:Unknown | -525.00= EUR | -258.30 EUR | >> >> Couldn't we specify somehow the field separator as an extra header >> argument? I've looked for such an already existing in >> http://orgmode.org/manual/Specific-header-arguments.html#Specific-header= -arguments, >> but that does not seem to be available yet. > > This would probably be a good addition to ob-sh (and any other language > which doesn't have a defined list syntax). I'll have a deep look in the proposed direction. > I'll add this idea to the babel dev stack, but I'm swamped for the next w= eek > or so. If it's for holidays, enjoy it! (and, accessorily, come back full of energy=C2=A0;-)) Best regards, Seb --=20 S=C3=A9bastien Vauban _______________________________________________ Emacs-orgmode mailing list Please use `Reply All' to send replies to the list. Emacs-orgmode-mXXj517/zsQ@public.gmane.org http://lists.gnu.org/mailman/listinfo/emacs-orgmode