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

[james2vegas]

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.

[hujunsimon]

sorry, yes i pasted it wrong, :-( !

[hujunsimon]

not quite sure how to use {quote_char => q<'>, allow_whitespace => 1}, please explain a bit more !