[ale] CSV file parser or alternative

[Jim Seymour]

On Sat, 2006-08-05 at 14:10 -0400, Mike Fletcher wrote:
> 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

Thanks Mike,

I will take another look at it. From what I had read before, I couldn't
figure out how to import selected row/column combinations. I am just
trying to find the easiest, fastest way to import the data on a daily
basis.

-- 
Jim Seymour <bluejay at speedfactory.net>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 189 bytes
Desc: This is a digitally signed message part