in reply to 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.

      ... 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.