[Pdx-pm] reading a broken CSV file
Colin Kuskie
ckuskie at dalsemi.com
Fri Nov 21 18:19:55 CST 2003
On Fri, Nov 21, 2003 at 04:35:12PM -0800, Eric Shore Baur wrote:
>
> Is there any neat/slick way to get this data in there on the first
> pass? I tried using ParseWords, but I'm not sure if I utilized it to its
> fullest extent. I briefly played with a CSV driver for DBI, but it
> couldn't handle things split over the newlines, either.
If the number of columns in each file is a constant, then you could try
the following:
Get a line.
Feed it into some module that handles CSV and returns an array of elements
Do I have enough columns?
NO: Remove newline from present line;
Fetch another line from file;
Append it to the current line and check again.
YES: Push data into database.
More information about the Pdx-pm-list
mailing list