Beefy Boxes and Bandwidth Generously Provided by pair Networks
Keep It Simple, Stupid
 
PerlMonks  

Re^2: Recommendations for parsing invalid CSV

by markjugg (Curate)
on Apr 21, 2008 at 14:37 UTC ( #681929=note: print w/ replies, xml ) Need Help??


in reply to Re: Recommendations for parsing invalid CSV
in thread Recommendations for parsing invalid CSV

I am not. I'm working with an export of an older version of the "TimeMatters" software.

Regarding what Text::CSV_XS can do, in summary are you saying that one of the "allow_loose_quotes" or "allow_loose_escapes" option can or will be able to handle this?

That would certainly be the easiest path for me. Thanks so much for the fast and helpful response!


Comment on Re^2: Recommendations for parsing invalid CSV
Re^3: Recommendations for parsing invalid CSV
by Tux (Monsignor) on Apr 21, 2008 at 14:45 UTC

    Yes. You'd have to play with allow_loose_quotes, allow_loose_escapes and/or setting escape_char to undef to find your best combination. The upcoming 0.43 has a new util examples/csv-check, which will tell you line number and position in-line of where the first failure happens


    Enjoy, Have FUN! H.Merijn

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://681929]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others pondering the Monastery: (14)
As of 2015-07-06 20:16 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The top three priorities of my open tasks are (in descending order of likelihood to be worked on) ...









    Results (83 votes), past polls