:P
--
me
- Original Message -
From: "Timothy Johnson" <[EMAIL PROTECTED]>
To: "'Chris Knipe'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Thursday, February 20, 2003 10:55 PM
Subject: RE: CSV inports...
>
> I would use DBD::CSV or (I think) Tex
Manning. You can find it at amazon.
jab
On Thu, 20 Feb 2003, Paul wrote:
> Date: Thu, 20 Feb 2003 12:54:14 -0800 (PST)
> From: Paul <[EMAIL PROTECTED]>
> Reply-To: [EMAIL PROTECTED]
> To: John Baker <[EMAIL PROTECTED]>, Chris Knipe <[EMAIL PROTECTED]>
> Cc: [EM
I would use DBD::CSV or (I think) Text::CSV. I have a routine that I tried
to use in the past, but it gets more complicated than the split solution:
open(INFILE,"myfile.csv");
while(){
my @fields;
while($_ =~ /(\".*\")?,?([^\"]*)/g){
push @fields,$1;
push @fields,split(/,/,$2);
--- John Baker <[EMAIL PROTECTED]> wrote:
> 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.
O'Reilly?
__
Do you Yahoo!?
Yahoo! Tax Center - fo
--- Chris Knipe <[EMAIL PROTECTED]> wrote:
> 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"
Try this:
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 PROTECTE
> 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"
>
> How would I go about fixing this little issue?
T
