note Tux <p>The "best" is of course [mod://Text::CSV_XS] :)</p> <p>[mod://Text::CSV] is just a wrapper over [mod://Text::CSV_XS] and/or [mod://Text::CSV_PP].</p> <p>If your CSV data is mixed <i>and</i> invalid, chances are that you might not find a combination of options that will work on <i>all</i> records, but a good start for what you describe would be something like:</p> <code> my $csv = Text::CSV_XS->new ({ binary => 1, allow_loose_quotes => 1, escape_char => undef, auto_diag => 1, }); </code> <p>Please carefully read the [http://search.cpan.org/dist/Text-CSV_XS/CSV_XS.pm|manual] for all [http://search.cpan.org/dist/Text-CSV_XS/CSV_XS.pm#new|<c>allow_***</c>] options.</p> <!-- Node text goes above. Div tags should contain sig only --> <div class="pmsig"><div class="pmsig-200365"> <br /> Enjoy, Have FUN! H.Merijn </div></div> 1000599 1000599