Re: Script to convert CSV to formatted plain text table

2009-06-24 Thread Rodney Schmidt
...@gmail.com Subject: Re: Script to convert CSV to formatted plain text table At 16:18 +0100 on 06/16/2009, Carlton Gibson wrote about Re: Script to convert CSV to formatted plain text table: Thanks for the reply... I meant to take something like this: col1,col2,col3 xx,xxx,x and turn

Re: Script to convert CSV to formatted plain text table

2009-06-23 Thread Robert A. Rosenberg
At 16:18 +0100 on 06/16/2009, Carlton Gibson wrote about Re: Script to convert CSV to formatted plain text table: Thanks for the reply... I meant to take something like this: col1,col2,col3 xx,xxx,x and turn it into something like: *** * col1 * col2 * col3

Re: Script to convert CSV to formatted plain text table

2009-06-17 Thread Carlton Gibson
Hi Charlie, On 17 Jun 2009, at 06:51, Charlie Garrison wrote: If you're happy with Perl, then the Text::Table module will do what you want: http://search.cpan.org/perldoc?Text::Table Thanks that looks like it will do it! Regards, Carlton

Re: Script to convert CSV to formatted plain text table

2009-06-17 Thread Carlton Gibson
On 17 Jun 2009, at 09:53, steveax wrote: There's entable: http://entable.s3.amazonaws.com/index.html HTH, Brilliant! Thanks. (I knew someone had done this before.) --~--~-~--~~~---~--~~ You received this message because you are subscribed to the

Re: Script to convert CSV to formatted plain text table

2009-06-17 Thread pete boardman
On 16 Jun 2009, at 09:15, Carlton wrote: I don't suppose anyone has a filter for converting (say) CSV into an ASCII table do they? Nice to see some home-brewed solutions, and not all in Perl :)! Here's a short and simple script in newLISP: #!/usr/bin/env newlisp (set 'file (open

Script to convert CSV to formatted plain text table

2009-06-16 Thread Carlton
Hi all, I don't suppose anyone has a filter for converting (say) CSV into an ASCII table do they? (I'm after the sort of thing you get from, say, the MySQL command line client.) My Google skills seemed to have failed me. Thanks, Carlton --~--~-~--~~~---~--~~ You

Re: Script to convert CSV to formatted plain text table

2009-06-16 Thread G. T. Stresen-Reuter
Import into mysql and pipe query to file? Ted Sent from my iPhone On Jun 16, 2009, at 9:15 AM, Carlton carlton.gib...@gmail.com wrote: Hi all, I don't suppose anyone has a filter for converting (say) CSV into an ASCII table do they? (I'm after the sort of thing you get from, say, the

Re: Script to convert CSV to formatted plain text table

2009-06-16 Thread Carlton Gibson
Hi Ted, On 16 Jun 2009, at 09:36, G. T. Stresen-Reuter wrote: Import into mysql and pipe query to file? That may well work. It's a bit sledgehammer to crack a nut though — :-) — and I'd need a table defined already... I was thinking that some PERL script or a clever pipeline (perhaps

Re: Script to convert CSV to formatted plain text table

2009-06-16 Thread Carlton Gibson
Hi All, A bit of further browsing and it seems EMACS has a whole set of Text Based Tables functionality: http://www.impernix.org/Manuals/emacs/Text-Based-Tables.html#Text-Based-Tables I'm wondering does anybody know if the code behind this (or equivalent) is available as a stand-alone

Re: Script to convert CSV to formatted plain text table

2009-06-16 Thread Doug McNutt
Assuming the OP meant, by ASCII table, a flow of text that will appear in a BBEedit window as a table the real answer is no way. It might be possible to demand a constant width font and add space characters to make such a file appear as a table of sorts but editing the contents would be

Re: Script to convert CSV to formatted plain text table

2009-06-16 Thread Doug McNutt
At 16:18 +0100 6/16/09, Carlton Gibson wrote: I meant to take something like this: col1,col2,col3 xx,xxx,x and turn it into something like: *** * col1 * col2 * col3 * *** * xx * xxx * x * *** Readers: Switch to a

Re: Script to convert CSV to formatted plain text table

2009-06-16 Thread Aaron W. Hsu
Carlton, I don't know if this is what you are looking for, but here's a quick and dirty version of what you described. From carlton.gib...@gmail.com Tue Jun 16 12:04:30 2009 I don't suppose anyone has a filter for converting (say) CSV into an ASCII table do they? (I'm