Beefy Boxes and Bandwidth Generously Provided by pair Networks
more useful options
 
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 examining the Monastery: (12)
As of 2014-09-19 18:58 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    How do you remember the number of days in each month?











    Results (144 votes), past polls