Text::xSV handles this better than Text::CSV and Text::CSV_XS. Don't write code to parse the data - have the module do the work for you.

Yes Text::xSV is by far better. It has proven more useful than the other soltuions.

Thanks everyone!