July 25, 2007
3:41 p.m.
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.