in reply to Parsing CSV file

This tool has already been written (and perfected) and most importantly it's sitting on your drive with mysql.

mysqlimport is a standard mysql utility.

It takes just a few minutes to read throught the man page for mysqlimport and setup the command to import your CSV file. Then you can spend you valuable time writing perl code :)



grep
Just me, the boy and these two monks, no questions asked.

Replies are listed 'Best First'.
Re: Re: Parsing CSV file
by illc0mmunication (Initiate) on Aug 11, 2002 at 02:21 UTC
    DBD::CSV worked like a charm, don't know why I didn't see it before. DUH!

    I first tried mysqlimport, but it has problems with the line breaks in the memo field.

    Thanks everyone for your help.

[reply]

In Section Seekers of Perl Wisdom