Re: [O] Computing the value of some cells of a table using a named code block
Hi Michael, Michael Brand writes: > When there is no named source block involved I use just > > | Category | Budget | Spending | > |--++--| > | Food | 1000 | Food | > | Rent | 1000 | Rent | > #+TBLFM: $3 = '(org-trim (shell-command-to-string (concat "echo " $1))) > > For named source blocks there is sbe, see Worg. This is most useful, thanks a lot! For the record, here is the solution using org-sbe: --8<---cut here---start->8--- #+name: spending #+begin_src sh :var c="bar" :results silent expr $c #+end_src | Category | Budget | Spending | |--++--| | Food | 1000 | Food | | Rent | 1000 | Rent | #+TBLFM: $3='(org-sbe "spending" (c (concat "\"" $1 "\""))) --8<---cut here---end--->8--- Thanks again, Alan
Re: [O] Computing the value of some cells of a table using a named code block
Hi Alan On Wed, Apr 2, 2014 at 1:58 PM, Alan Schmitt wrote: > I have a table that summarizes my monthly budget, and I would like to > add a column where I compute my actual spending. I can get this > information using a shell script, but I don't know how to integrate it > in the table. > > Here is a contrived example: > --8<---cut here---start->8--- > #+name: spending > #+begin_src sh :var category="foo" > echo $category > #+end_src > > | Category | Budget | Spending | > |--++--| > | Food | 1000 | | > | Rent | 1000 | | > #+TBLFM: $3=call_spending("$1") > --8<---cut here---end--->8--- > > My question is: how do I write the TBLFM so that every cell of column > 3 is the result of call the named block with column 1 as argument? When there is no named source block involved I use just | Category | Budget | Spending | |--++--| | Food | 1000 | Food | | Rent | 1000 | Rent | #+TBLFM: $3 = '(org-trim (shell-command-to-string (concat "echo " $1))) For named source blocks there is sbe, see Worg. Michael
[O] Computing the value of some cells of a table using a named code block
Hello, I have a table that summarizes my monthly budget, and I would like to add a column where I compute my actual spending. I can get this information using a shell script, but I don't know how to integrate it in the table. Here is a contrived example: --8<---cut here---start->8--- #+name: spending #+begin_src sh :var category="foo" echo $category #+end_src | Category | Budget | Spending | |--++--| | Food | 1000 | | | Rent | 1000 | | #+TBLFM: $3=call_spending("$1") --8<---cut here---end--->8--- My question is: how do I write the TBLFM so that every cell of column 3 is the result of call the named block with column 1 as argument? Thanks, Alan