recognize comma separated text as table?

recognize comma separated text as table?

[Sivaram Neelakantan]

I've been using org mode tables where possible and I frequently
receive data as csv, is there any any org-table function to transform
the csv function to org tables?

 sivaram
 -- 

Re: recognize comma separated text as table?

[William Henney]

On 9/25/07, Sivaram Neelakantan <nsivaram.net@gmail.com> wrote:
>
> I've been using org mode tables where possible and I frequently
> receive data as csv, is there any any org-table function to transform
> the csv function to org tables?
>

You could use org-table-import after converting all commas to tabs
with query-replace (or sed, or whatever). Only problem would be if
there were commas in quoted strings....

Cheers

Will

-- 

  Dr William Henney, Centro de Radioastronomía y Astrofísica,
  Universidad Nacional Autónoma de México, Campus Morelia

Re: recognize comma separated text as table?

[Bastien]

"William Henney" <whenney@gmail.com> writes:

> You could use org-table-import after converting all commas to tabs
> with query-replace (or sed, or whatever). Only problem would be if
> there were commas in quoted strings....

Stupid heuristic would compute the average number of commas per line,
and the average number of characters per quoted string. But doesn't csv
exporters already escape commas when they are part of a cell? Maybe they
should.

-- 
Bastien

Re: recognize comma separated text as table?

[Carsten Dominik]

On Sep 25, 2007, at 11:31, Sivaram Neelakantan wrote:

>
> I've been using org mode tables where possible and I frequently
> receive data as csv, is there any any org-table function to transform
> the csv function to org tables?

I guess I can generalize the import and conversion commands to handle 
CSV
material.  Should be easy, to it'll be in 5.10.

- Carsten



--
Carsten Dominik
Sterrenkundig Instituut "Anton Pannekoek"
Universiteit van Amsterdam
Kruislaan 403
NL-1098SJ Amsterdam
phone: +31 20 525 7477

Re: recognize comma separated text as table?

[Sivaram Neelakantan]

Carsten Dominik <carsten.dominik@gmail.com> writes:

> On Sep 25, 2007, at 11:31, Sivaram Neelakantan wrote:
>
>>
>> I've been using org mode tables where possible and I frequently
>> receive data as csv, is there any any org-table function to transform
>> the csv function to org tables?
>
> I guess I can generalize the import and conversion commands to handle
> CSV
> material.  Should be easy, to it'll be in 5.10.
>
> - Carsten

While at that, is there a possibility of getting horizontal rules too,
please?  To separate one row from another.

sivaram

--