Influence the table separator in a code block

Influence the table separator in a code block

[Wiktor Kwapisiewicz]

Hello,

I'm using #+BEGIN_SRC sh code blocks and org-mode nicely renders the
output as a table:

#+BEGIN_SRC sh
  echo FIRST   SECOND   THIRD
  echo first second third
#+END_SRC

#+RESULTS:
| FIRST | SECOND | THIRD |
| first | second | third |

And this is very nice. Unfortunately the autodetection breaks when any
item contains a comma (,):

#+BEGIN_SRC sh
  echo FIRST   SECOND   THIRD
  echo first second third,d
#+END_SRC

#+RESULTS:
| FIRST SECOND THIRD |   |
| first second third | d |

I tried to force org to use spaces by using "sep". Unfortunately this
doesn't work:

#+BEGIN_SRC sh :sep " "
  echo FIRST   SECOND   THIRD
  echo first second third,d
#+END_SRC

#+RESULTS:
| FIRST SECOND THIRD |   |
| first second third | d |

Is there a way to force org to split on spaces even when commas are in
the output?

Thank you in advance for help!

Kind regards,
Wiktor

Re: Influence the table separator in a code block

[Greg Minshall]

fwiw, this may depend on the source language (rather than -- solely? --
on org interpretation of the output block:

#+begin_src R
  data.frame(a=c("this", "is", "a", "test"), b=c("tset", "a", "si", "oot, siht"))
#+end_src

#+RESULTS:
| this | tset      |
| is   | a         |
| a    | si        |
| test | oot, siht |