Re: [O] Using Code Blocks in Org Tables

2011-08-28 Thread Eric Schulte
Henri-Paul Indiogine hindiog...@gmail.com writes:

 Hi Eric!

 2011/8/26 Eric Schulte schulte.e...@gmail.com:
 sh code blocks are different in that they don't really have a :results
 value option in the same way as most code blocks.  Two options would be
 to either
 1. remove the echo $HOME line from your code blocks, or
 2. change the '(sbe test-sh) formula to '(second (second (sbe test-sh)))

 I was going by: http://orgmode.org/worg/org-contrib/babel/intro.html#results

 Capturing the results of code evaluation.
 The 'result' of code evaluation is the value of the last statement in
 the code block. 

 I have a long bash script that outputs a lot of information to a log
 file.   But I would like one piece of information to end up in a cell
 of an org-mode table.   I can place this value as the last one in the
 bash script.  How could I make that work?


Hi Henri-Paul,

You could define another code block which could be used to take just the
last line of the output, e.g.,

#+source: stuff
#+begin_src sh
  echo 1
  echo 2
  echo 3
#+end_src

#+source: last-of-stuff
#+begin_src sh :var input=stuff
  echo $input |tail -1
#+end_src

| one |
| two |
| 3   |
#+TBLFM: @3$1='(sbe last-of-stuff)

Hope this helps -- Eric


 Thanks,
 Henri-Paul

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



Re: [O] Using Code Blocks in Org Tables

2011-08-28 Thread Henri-Paul Indiogine
Hi Eric!

2011/8/28 Eric Schulte schulte.e...@gmail.com:

 #+source: last-of-stuff
 #+begin_src sh :var input=stuff
  echo $input |tail -1
 #+end_src

 | one |
 | two |
 | 3   |
 #+TBLFM: @3$1='(sbe last-of-stuff)

Your solution works very well.

Thanks!

Henri-Paul


-- 
Henri-Paul Indiogine

Curriculum  Instruction
Texas AM University
TutorFind Learning Centre

Email: hindiog...@gmail.com
Skype: hindiogine
Website: http://people.cehd.tamu.edu/~sindiogine



Re: [O] Using Code Blocks in Org Tables

2011-08-26 Thread Eric Schulte
Henri-Paul Indiogine hindiog...@gmail.com writes:

 I am trying to have the final output of several bash script appear in
 a summary table.

 I am trying to follow this example:
 http://orgmode.org/worg/org-contrib/babel/intro.html#spreadsheet

 This is my test system:

 -8---8-
 #+tblname: test
 #+CAPTION: test
 #+LABEL: tbl:test
 | collection | number   |
 |+--|
 | congr-hearings | ((/home/henk) (2)) |
 | congr-bills|  |
 | pres-docs  |  |
 | eric-docs  |  |
 #+TBLFM: @2$2='(sbe test-sh)

 #+srcname: test-sh
 #+begin_src sh  :results value
 x=2
 echo $HOME
 echo $x
 #+end_src

 #+results: test-sh
 | /home/henk |
 |  2 |

 ---8-8

 I want actually to have only the number 2 in cell @2$2.  I thought
 that with :results value only the final output of the script, i.e.
 the output of echo $x would appear.  Instead the results of all echo
 statement do appear.


sh code blocks are different in that they don't really have a :results
value option in the same way as most code blocks.  Two options would be
to either
1. remove the echo $HOME line from your code blocks, or
2. change the '(sbe test-sh) formula to '(second (second (sbe test-sh)))


 What am I doing wrongly?


Nothing wrong, you just weren't aware of the idiosyncrasies of the sh
code blocks.  I suppose that we could change the behavior of :results
value on sh blocks such that it only returns the last line of output,
but depending on who you ask value means different things on sh blocks
(e.g., possibly the return value of the last statement $?).

Best -- Eric


 Thanks,
 Henri-Paul

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



Re: [O] Using Code Blocks in Org Tables

2011-08-26 Thread Henri-Paul Indiogine
Hi Eric!

2011/8/26 Eric Schulte schulte.e...@gmail.com:
 sh code blocks are different in that they don't really have a :results
 value option in the same way as most code blocks.  Two options would be
 to either
 1. remove the echo $HOME line from your code blocks, or
 2. change the '(sbe test-sh) formula to '(second (second (sbe test-sh)))

I was going by: http://orgmode.org/worg/org-contrib/babel/intro.html#results

Capturing the results of code evaluation.
The 'result' of code evaluation is the value of the last statement in
the code block. 

I have a long bash script that outputs a lot of information to a log
file.   But I would like one piece of information to end up in a cell
of an org-mode table.   I can place this value as the last one in the
bash script.  How could I make that work?

Thanks,
Henri-Paul

-- 
Henri-Paul Indiogine

Curriculum  Instruction
Texas AM University
TutorFind Learning Centre

Email: hindiog...@gmail.com
Skype: hindiogine
Website: http://people.cehd.tamu.edu/~sindiogine



[O] Using Code Blocks in Org Tables

2011-08-25 Thread Henri-Paul Indiogine
I am trying to have the final output of several bash script appear in
a summary table.

I am trying to follow this example:
http://orgmode.org/worg/org-contrib/babel/intro.html#spreadsheet

This is my test system:

-8---8-
#+tblname: test
#+CAPTION: test
#+LABEL: tbl:test
| collection | number   |
|+--|
| congr-hearings | ((/home/henk) (2)) |
| congr-bills|  |
| pres-docs  |  |
| eric-docs  |  |
#+TBLFM: @2$2='(sbe test-sh)

#+srcname: test-sh
#+begin_src sh  :results value
x=2
echo $HOME
echo $x
#+end_src

#+results: test-sh
| /home/henk |
|  2 |

---8-8

I want actually to have only the number 2 in cell @2$2.  I thought
that with :results value only the final output of the script, i.e.
the output of echo $x would appear.  Instead the results of all echo
statement do appear.

What am I doing wrongly?

Thanks,
Henri-Paul




-- 
Henri-Paul Indiogine

Curriculum  Instruction
Texas AM University
TutorFind Learning Centre

Email: hindiog...@gmail.com
Skype: hindiogine
Website: http://people.cehd.tamu.edu/~sindiogine