Parsing CSV files with embedded newlines in Perl
Need to parse CSV (comma-separated values) files which contain embedded newlines in the fields, as produced by many applications including MS Excel? The usual Perl modules Text::CSV, Text::CSV_XS and CSV.pm can’t do it. Fortunately there is one that can, called Text::xSV. Find it on CPAN. I’m posting about it here to raise awareness because Google searches threw up lots of people asking about this but the answer was not obvious.
March 28th, 2011 at 3:01 pm
not sure if it will work, I will try Text::xSV. Anyways thanks in advance for the information