in reply to CSV cleanup problem...
I guess my recommendation would be to try a regex similar to kaif's and then feed the result to Text::CSV_XS and check a) for parse errors and b) to see if you have the correct number of fields. Then write the lines that fail a or b into a separate file and deal with them by hand. (I know, yuck, but, garbage in, garbage out).
|
---|
In Section
Seekers of Perl Wisdom