Re: CSV inports...

2003-02-20 Thread Chris Knipe
: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

Re: CSV inports... [OT]

2003-02-20 Thread John Baker
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

RE: CSV inports...

2003-02-20 Thread Timothy Johnson
push @fields,split(/,/,$2); } print OUTFILE join(',',@fields); } -Original Message- From: Chris Knipe [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 20, 2003 12:34 PM To: [EMAIL PROTECTED] Subject: CSV inports... Lo all, I got a little problem with a CSV imp

Re: CSV inports... [OT]

2003-02-20 Thread Paul
--- 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

Re: CSV inports...

2003-02-20 Thread Paul
--- 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:

Re: CSV inports...

2003-02-20 Thread John Baker
> 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 val

RE: CSV inports...

2003-02-20 Thread Mark Anderson
> 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

CSV inports...

2003-02-20 Thread Chris Knipe
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