[Wlug] Any SQL-types out there? (more lab automation stuff)

[Chuck Anderson]

On Wed, Jul 25, 2007 at 09:29:43AM -0400, Stephen Daukas wrote:
> There are literally hundreds of files of data in CSV format, and I intend to
> process each by itself, preserving the original, and creating a new
> "adjusted" file for the next step.  (The next step would be to concatenate
> all files together for numeric processing.)  Original files must be
> preserved (chain of custody requirements), so I am opening the file,
> selecting records using SQL, and am now ready to do the rearranging/writing
> to a new file...

So you are selecting records out of a CSV file using SQL?  How about 
this:

select columnB,columnG,columnA,columnC,columnF from foo;

That will take the columns and return them in the given order.