preserve trailing zeros in table output from shell script

preserve trailing zeros in table output from shell script

[Joseph A. Cua]

I have a reporting shell script that generates a tab-delimited table.
Using it within a shell code block, org parses this nicely into an org
table. But org seems to drop any trailing zeros from numeric cells. My
reporting script has already done the number formatting, so I want
trailing zeros preserved (both within org and in html export). What's
the best way?

Thanks,
Joe

Re: preserve trailing zeros in table output from shell script

[suvayu ali]

On Sat, Jul 14, 2012 at 2:35 PM, Joseph A. Cua <jac89@cornell.edu> wrote:
> I have a reporting shell script that generates a tab-delimited table.
> Using it within a shell code block, org parses this nicely into an org
> table. But org seems to drop any trailing zeros from numeric cells. My
> reporting script has already done the number formatting, so I want
> trailing zeros preserved (both within org and in html export). What's
> the best way?
>

Some examples would help.

-- 
Suvayu

Open source is the future. It sets us free.

Re: preserve trailing zeros in table output from shell script

[Eric Schulte]

[-- Attachment #1: Type: text/plain, Size: 648 bytes --]

"Joseph A. Cua" <jac89@cornell.edu> writes:

> I have a reporting shell script that generates a tab-delimited table.
> Using it within a shell code block, org parses this nicely into an org
> table. But org seems to drop any trailing zeros from numeric cells. My
> reporting script has already done the number formatting, so I want
> trailing zeros preserved (both within org and in html export). What's
> the best way?
>

If you want to return the numbers as strings *and* you want the results
to be captured as an Org-mode table, then you should use the ":results
org" output type so that you have complete control over the table.

For example,


[-- Warning: decoded text below may be mangled, UTF-8 assumed --]
[-- Attachment #2: results-org.org --]
[-- Type: text/x-org, Size: 125 bytes --]


#+begin_src sh :results output org :exports results
  cat <<EOF
  | 1.0000 | 22.000 |
  | 333.00 | 4444.0 |
  EOF
#+end_src

[-- Attachment #3: Type: text/plain, Size: 53 bytes --]


Best,

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