[O] Spreadsheet calculations (24.3/8.0-pre)

Hi, I'm trying to do some simple calculations, but the results are plain wrong. I started the minimal example with `emacs -Q -l minimal.emacs org/minimal.org'. My Emacs is 24.3 with Org-mode version 8.0-pre (release_8.0-pre-116-g65cde8 @ /home/ov/p/org-mode/lisp/): #+TITLE: Nutrition Facts #+CO

Re: [O] Spreadsheet calculations (24.3/8.0-pre)

Hi Bastien, > #+CONSTANTS is meant to be used only once on the file, not per table. that's how I understood it. > When used several times, `org-table-formula-constants-local' was > defining the same constant several times, which is wrong. I fixed > this. I can confirm this is working now. > L

Re: [O] Spreadsheet calculations (24.3/8.0-pre)

Hi Ippei, > | Product |g | kJ/100g | kJ | kcal | > |---+--+-+--+--| > | Bread | 50.6 |1372 | 694 | 166 | > | Butter| 11.5 |3054 | 351 | 84 | > | Marmalade | 19.7 | 926 | 182 | 44 | > |---+--+-+--+--| > |

[O] filter included files

Hi, I like to include files from the network to document their status at the time of publication e.g.: #+INCLUDE: "/:/etc/iptables/iptables.rules" example But sometimes I'd like to do some more filtering (sed, whatever), to remove passwords or other sensible information from the output. Is th

Re: [O] Can I specify the location of generated html in org 8?

>So is there any way to change the location of the table of contents >parts? What I did recently was disabling toc in the header and putting it in the document later (info "(org) Table of contents"): #+OPTIONS: toc:nil #+BEGIN_HTML --- layout: org id: elispintro title: An Introduction To

Re: [O] filter included files

> I like to include files from the network to document their status at the > time of publication e.g.: > > #+INCLUDE: "/:/etc/iptables/iptables.rules" example > > But sometimes I'd like to do some more filtering (sed, whatever), to > remove passwords or other sensible information from the output.

Re: [O] filter included files

> To answer my own question, I still don't know if this is 'best > practice', but this worked for me quite well: > > #+BEGIN_SRC sh :exports results :results output > ssh cat /etc/iptables/iptables.rules | sed 's/pattern/string/' > #+END_SRC oops, useless use of cat: #+BEGIN_SRC sh :exports resu

[O] diff in `src' blocks

Hi, in the following org file the second block gets not exported (tested with text and html exporter, release_8.0.2-119-g646f1a): --8<---cut here---start->8--- #+OPTIONS: toc:nil author:nil #+BEGIN_SRC sh :exports results :results output cat testdiff.txt.orig

Re: [O] diff in `src' blocks

> Why is the `diff' command alone not exported while the piped `diff' via > `cat' works? Is this this a bug? Figured out myself, sorry for the noise. It has to do with the exit status of the `diff', which is 1 if the files are different. So I use the pipe through `cat'.

Re: [O] diff in `src' blocks

>> Figured out myself, sorry for the noise. It has to do with the exit >> status of the `diff', which is 1 if the files are different. So I use >> the pipe through `cat'. > > Useless use of cat... At least the return status is zero. But I agree with you, a colon is better here. This is my firs

[O] sqlite im-/export

Hi, I've got a small test case which I believe is a bug: $ cat t1.sql PRAGMA foreign_keys=OFF; BEGIN TRANSACTION; CREATE TABLE t1(id integer,product text); INSERT INTO "t1" VALUES(1,'apple pie'); INSERT INTO "t1" VALUES(2,'sugar'); COMMIT; sqlite3 test.sqlite < t1.sql #+BEGIN_SRC sh echo "ID|pro

Re: [O] sqlite im-/export

Eric Schulte 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

Re: [O] sqlite im-/export

Eric Schulte writes: > 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 >

Re: [O] sqlite im-/export

> 2. use ":results drawer", and explicitly formatting the results in >Org-mode syntax w/awk Unfortunately this doesn't work. The output is always printed to the "#+RESULTS:" section and not piped through awk. But working with ":results raw" works perfect for me. I can even produce a separat

Re: [O] sqlite im-/export

> I may have missed you spelling this out in a previous email, but can you > not import Org tables directly into sqlite code blocks? > > Evaluate this again after evaluating the second block. > #+BEGIN_SRC sqlite :csv :db test.sqlite > SELECT * from t1; > #+END_SRC This works like a charm, thank