Try the Text::CSV_XS mod. I believe it rectifies double quote
problems. That topic was covered in the Data Munging with Perl
book. Decent book, btw.
jab
On Thu, 20 Feb 2003, Chris Knipe wrote:
> Date: Thu, 20 Feb 2003 22:33:45 +0200
> From: Chris Knipe <[EMAIL PROTECTED]>
> To: [EMAIL PROTECTED]
> Subject: CSV inports...
>
> Lo all,
>
> I got a little problem with a CSV import... It should be rather straight
> forward to people who do this often.. so I'm hoping for some help...
>
> I have a MS Excel exported CSV text file, with , separated values. The
> problem now, is that some of the values also contains a , character, and MS
> Excel thus put the values in a quote such as:
> "blah, blah", blah, "blah, blah, blah"
>
> I have:
> open(FILE, "<CC.csv");
> while (<FILE>) {
> my ($CK, $NAME, $ADDRESS, $TYPE) = split(',', $_);
> }
> close(FILE);
>
> But this obviously does not work, seeing that it ignores values included in
> the quotes "...
>
> How would I go about fixing this little issue?
>
> --
> me
>
>
> --
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
>
>
--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
