parse CSV

kevind0718 has asked for the wisdom of the Perl Monks concerning the following question:

Replies are listed 'Best First'.
Re: parse CSV by Tux (Canon) on Sep 17, 2007 at 15:34 UTC
There's actually only two base modules Text::CSV_XS if you have a C compiler or Text::CSV_PP if you do not. Most other modules depend on Text::CSV_XS Enjoy, Have FUN! H.Merijn	[reply]
Re^2: parse CSV by planetscape (Chancellor) on Sep 17, 2007 at 18:15 UTC
There's also AnyData::Format::CSV. Personally, I'm a big fan of the AnyData family. :-) HTH, planetscape	[reply]
Re^3: parse CSV by Tux (Canon) on Sep 17, 2007 at 21:21 UTC
AnyData::Format::CSV uses regular expressions to parse the data, which is much slower than the parser Text::CSV_XS uses in C (XS). When using CSV data with databases, I'd advice DBD::CSV, which also uses Text::CSV_XS to parse Enjoy, Have FUN! H.Merijn	[reply]
Re^2: parse CSV by Joost (Canon) on Sep 17, 2007 at 19:33 UTC
There's also Text::xSV, which parsed all "valid" CSV files I've ever thrown at it, but it seems a bit less extensible than Text::CSV_XS. "What should it profit a man, if he should win a flame war, yet lose his cool?"	[reply]
Re: parse CSV by cosmicperl (Chaplain) on Sep 17, 2007 at 23:08 UTC
I've always used Text::CSV, I like it because I can get it working without doing a proper make install (just grabbing the .pm module). That means I can easily through it in with a script I produce and don't have to worry about the resulting server having the module installed. After all they may be on shared hosting, and unable to do a proper make install. Lyle Hopkins I tell a little lie, I also had to copy over another file, but I can't remember what it was...	[reply]
Re^2: parse CSV by Tux (Canon) on Sep 17, 2007 at 23:35 UTC
FYI: The plan is to make Text::CSV a thin wrapper over Text::CSV_XS and Text::CSV_PP and use whatever is available (in that order). Maintainership has already been transferred to the author of Text::CSV_PP Enjoy, Have FUN! H.Merijn	[reply]