Beefy Boxes and Bandwidth Generously Provided by pair Networks
XP is just a number
 
PerlMonks  

Re: How to parse a csv file by comma, but ignore comma inside the single quotation

by james2vegas (Chaplain)
on Aug 03, 2011 at 14:12 UTC ( #918272=note: print w/replies, xml ) Need Help??


in reply to How to parse a csv file by comma, but ignore comma inside the single quotation

Is the paste of your file accurate, it doesn't quite match your description? If it is meant to be more like:
'car reg, location', 'gps string: lats:xxxx,longs:xxxxx, Alts:xxxx', ' +number of satellites fix';
then passing {quote_char => q<'>, allow_whitespace => 1} to Text::CSV->new should be enough.

Replies are listed 'Best First'.
Re^2: How to parse a csv file by comma, but ignore comma inside the single quotation
by hujunsimon (Sexton) on Aug 03, 2011 at 14:31 UTC
    not quite sure how to use {quote_char => q<'>, allow_whitespace => 1}, please explain a bit more !
Re^2: How to parse a csv file by comma, but ignore comma inside the single quotation
by hujunsimon (Sexton) on Aug 03, 2011 at 14:24 UTC
    sorry, yes i pasted it wrong, :-( !

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://918272]
help
Chatterbox?
[choroba]: yeah, sounds like one of the strings is not flagged as UTF-8
[choroba]: which usually means its input wasn't handled correctly
[Corion]: choroba: Yeah, I think that would be the good solution
[LanX]: I suspect the first string which comes from the DB ...
[LanX]: ... but this part is already in production for a year now
[Corion]: LanX: The "good" approach here would be to use the appropriate DBI parameters to make the driver decode strings properly. But that will have a ripple-on effect of messing up all the places where manual decoding happens ;)
[LanX]: which means albeit being broken UTF8 it'll be handled correctly
[LanX]: and the problem only occurs since we changed the emails to base64
[LanX]: my main problem will be to cnvince my colleagues that our productive code is broken oO ... so in the end I will just make a workaround :-/
LanX hates UTF8 for causing knots in his brain and stomach

How do I use this? | Other CB clients
Other Users?
Others cooling their heels in the Monastery: (9)
As of 2017-01-16 14:00 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    Do you watch meteor showers?




    Results (150 votes). Check out past polls.