Re: 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';
[download]

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 !	[reply]
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, :-( !	[reply]