[ale] CSV file parser or alternative

[Mike Fletcher]

On Aug 4, 2006, at 8:46 PM, Jim Seymour wrote:

> Hi All,
>
> I am looking for a way to pull certain row/column values from a csv  
> file
> to save in a text file that I can load into MySQL. I have not seen a
> direct way using MySQL to pull the data and load into the correct
> columns. The file is 15 lines long and is in this format;
>
> "ABIAX",20.63,"2006-08-03","6:00pm",-0.09,N/A,N/A,N/A,N/A
> "ACEIX",8.78,"2006-08-03","6:00pm",-0.03,N/A,N/A,N/A,N/A
> etc.....

mysqlimport should handle CSV with the right options.

http://dev.mysql.com/doc/refman/5.0/en/mysqlimport.html