Beefy Boxes and Bandwidth Generously Provided by pair Networks
"be consistent"
 
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.


Comment on Re: How to parse a csv file by comma, but ignore comma inside the single quotation
Select or Download Code
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?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others surveying the Monastery: (8)
As of 2015-09-01 08:54 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The oldest computer book still on my shelves (or on my digital media) is ...













    Results (368 votes), past polls