http://qs1969.pair.com?node_id=682173


in reply to Recommendations for parsing invalid CSV

Hi ,

Why not try Text::xSV ?

... then you don't have to bother about such things.

From experience, the only thing that can't handle is a CSV export by Excel where a field is extraordinarily large (such that the field is split ... by Excel) ?

At last, a user level that best describes my experience :-))

Replies are listed 'Best First'.
Re^2: Recommendations for parsing invalid CSV
by Tux (Canon) on Apr 23, 2008 at 06:26 UTC

    There might be several reasons for choosing the right   module. See here for a more thorrough discussion of the differences between the available CSV parsing modules.

    Note that this initial post is somewhat outdated, and some of the +/-'s might have changed. e.g. Text::CSV_XS not can deal very well with NULL (undef) values.


    Enjoy, Have FUN! H.Merijn