I've got a CSV file which I need to process. The format is as follows.
"Smith, John J",1/1/2002,1/15/2002,"Orlando, FL",Florida
"Doe, John L",1/1/2002,1/15/2002,Los Angeles, California
I've tried splitting it using: @row = split(",",$data);
The problem is with the fields that contain the commas between the quotes.
It's splitting the fields at each of these fields as well and I'd like to
know how to avoid that.
Any help is greatly appreciated!
Joshua Scott
Security Systems Analyst, CISSP
626-568-7024
==============================================================================
NOTICE - This communication may contain confidential and privileged
information that is for the sole use of the intended recipient. Any viewing,
copying or distribution of, or reliance on this message by unintended
recipients is strictly prohibited. If you have received this message in
error, please notify us immediately by replying to the message and deleting
it from your computer.
==============================================================================
