in reply to Re^2: CSV SPLIT
in thread CSV SPLIT
As kcott posted, there are almost no circumstances where you should use split to retrieve or store CSV data due to problems similar to those you've encountered. Text::CSV and its close relatives will happily get/put data between a CSV file and an array, and deal with the separators in data properly by quoting them. Once the row is in the array you can process it anyway you like.
If you post some example data and what you'd like to happen to it, perhaps we can give you a more detailed answer. Don't forget to use <code> tags to show your data in the question properly
If you spot any bugs in my solutions, it's because I've deliberately left them in as an exercise for the reader! :-)