How to get a table into a variable in a shell code block?

How to get a table into a variable in a shell code block?

[William Denton]

Let's say I have a table like this:

#+NAME: numbers
| one   |
| two   |
| three |

I want to run through those numbers in a shell code block, but it I pass in 
table as a variable, it only sees the first number.

#+begin_src shell :results output :var n=numbers
echo $n
#+end_src

#+RESULTS:
: one

In Ruby it sees the numbers as an array:

#+begin_src ruby :results output :var n=numbers
puts n
puts n.class
#+end_src

#+RESULTS:
: one
: two
: three
: Array

And in R sees them as a data.table with one column.  Both are very easy to 
iterate over, of course.

I looked at the docs, but didn't see this covered, then I looked at ob-shell.el 
and saw the "org-babel--variable-assignments:bash_array" function, which might 
or might not be relevant, but it's all beyond my comprehension.

Is there a way to get my shell code seeing all of the elements in the column?

Thanks,

Bill
--
William Denton :: Toronto, Canada   ---   Listening to Art: https://listeningtoart.org/
https://www.miskatonic.org/         ---   GHG.EARTH: https://ghg.earth/
Caveat lector.                      ---   STAPLR: https://staplr.org/

Re: How to get a table into a variable in a shell code block?

[Greg Minshall]

William,

try

#+begin_src shell :results output :var n=numbers
echo ${n[1]}
#+end_src

cheers, Greg

Re: How to get a table into a variable in a shell code block?

[William Denton]

On 3 April 2021, Greg Minshall wrote:

> #+begin_src shell :results output :var n=numbers
> echo ${n[1]}
> #+end_src

Aha, it's in an array but I didn't see it!  Thanks.  Org was doing it magic but 
I got confused by bash.

#+NAME: numbers
| one   |
| two   |
| three |

#+begin_src shell :results output :var n=numbers
for i in "${n[@]}"; do
     echo $i
done
#+end_src

#+RESULTS:
: one
: two
: three

Bill
--
William Denton :: Toronto, Canada   ---   Listening to Art: https://listeningtoart.org/
https://www.miskatonic.org/         ---   GHG.EARTH: https://ghg.earth/
Caveat lector.                      ---   STAPLR: https://staplr.org/

Re: How to get a table into a variable in a shell code block?

[Juan Manuel Macías]

Hi Greg and William,

Greg Minshall writes:

> William,
>
> try
>
> #+begin_src shell :results output :var n=numbers
> echo ${n[1]}
> #+end_src
>
> cheers, Greg

I don't know if I'm saying something wrong, but wouldn't it be better
this way?:

#+begin_src shell :results output :var n=numbers
echo ${n[@]}
#+end_src

echo ${n[1]} returns the second element (two) of the list (0, returns
one and 2 returns three)

Best regards,

Juan Manuel 

Re: How to get a table into a variable in a shell code block?

[Michael Welle]

Hello,

William Denton <wtd@pobox.com> writes:

> On 3 April 2021, Greg Minshall wrote:
>
>> #+begin_src shell :results output :var n=numbers
>> echo ${n[1]}
>> #+end_src
>
> Aha, it's in an array but I didn't see it!  Thanks.  Org was doing it magic but
> I got confused by bash.
interestingly I asked a similar question in #org-mode yesterday. I came
up with this approach:

* table test
** user data
#+name: userdata
| uid | name | foo   | bar  |
| a2s | a2   | afoo  | abar |
| b2s | b2   | bfoo  | bbar |
| c2s | c2   | c foo | cbar |

** code
#+begin_src sh :var userdata=userdata :separator , :results raw
  echo "$userdata" | while read line ; do
      IFS=','
      echo "$line" | while read u n f b ; do
          echo "u: $u n: $n f: $f b: $b"
      done
  done
#+end_src

This looks a bit clumsy, but should also work with shell that doesn't
support (2D) array type variables.

Regards
hmw