Anonymous Monk has asked for the wisdom of the Perl Monks concerning the following question:
Example CSV Record:
12345,Jim,,"""Smith, Jr.""",1234 W. Baker Ct., ,Ontario,CA,12345,123456789, ,,27-Apr-02,1234567
Even when using Text::CVS_XS, the "Jr." will be parsed as the address. Should I write a RegEx to substitute the comma with in the triple double quotes to a pipe (|) and then parse the record (only to substitute back to a "," before writing)? If so, I have no clue how to write the RegEx. For the record, I have tried to find answers on this site. I am not having any luck. Please advise.
Thanks in advance for any and all help!!!
CPB
|
|---|
| Replies are listed 'Best First'. | |
|---|---|
|
Re: Problems With Parsing CSV File
by grep (Monsignor) on Jul 22, 2002 at 05:47 UTC | |
|
Re: Problems With Parsing CSV File
by Anonymous Monk on Jul 22, 2002 at 11:17 UTC | |
|
Re: Problems With Parsing CSV File
by fuzzysteve (Beadle) on Jul 22, 2002 at 11:49 UTC |