Re: Split ignores certain data in a Quoted CSV file.

In addition to the advice to use strict and warnings to solve your problem, you might also consider using a CSV parser, such as Text::CSV_XS, because it can handle the more general case of embedded commas in your data.

Comment on Re: Split ignores certain data in a Quoted CSV file.

Replies are listed 'Best First'.
Re^2: Split ignores certain data in a Quoted CSV file. by ikegami (Patriarch) on Apr 06, 2010 at 19:09 UTC
It would be immediately useful for the OP as it would handle the dequoting.	[reply]
Re^3: Split ignores certain data in a Quoted CSV file. by snopal (Pilgrim) on Apr 07, 2010 at 15:23 UTC
... and while it doesn't seem present in the example data, any enquoted commas will divide a field and offset the results in an unexpected manner.	[reply]