Beefy Boxes and Bandwidth Generously Provided by pair Networks
Think about Loose Coupling

Re: Recommendations for parsing invalid CSV

by Tux (Canon)
on Apr 21, 2008 at 14:20 UTC ( #681925=note: print w/replies, xml ) Need Help??

in reply to Recommendations for parsing invalid CSV

Are you by any chance working together with Michael Fowler? He asks almost the same thing in this RT entry.

See my comments there.

Enjoy, Have FUN! H.Merijn
  • Comment on Re: Recommendations for parsing invalid CSV

Replies are listed 'Best First'.
Re^2: Recommendations for parsing invalid CSV
by markjugg (Curate) on Apr 21, 2008 at 14:37 UTC
    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!

      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?

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

How do I use this? | Other CB clients
Other Users?
Others taking refuge in the Monastery: (8)
As of 2023-05-29 15:44 GMT
Find Nodes?
    Voting Booth?

    No recent polls found