CSV cleanup problem...by devnul (Monk)
|on Jun 14, 2005 at 01:43 UTC||Need Help??|
devnul has asked for the
wisdom of the Perl Monks concerning the following question:
I have a CSV file which needs some cleanup in order for Text::CSV_XS to be able to parse it. I know what I need to do, just not sure how to do it.
First a sample:
This breaks up into 3 fields:
I can get the above to work if I change the above to:
This required two changes:
#1. Changing /", "/ to /",/
#2. Double-quoting some wierd title
I can do #1 with a regex with no difficulty, but have no idea how to do #2.