[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[ale] CSV file parser or alternative
- Subject: [ale] CSV file parser or alternative
- From: fletch at phydeaux.org (Mike Fletcher)
- Date: Sat, 5 Aug 2006 14:10:24 -0400
- In-reply-to: <[email protected]>
- References: <[email protected]>
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