Try using the Text::CSV module...
On Fri, 2003-01-17 at 10:12, Scott, Joshua wrote:
> 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.
>
> ==============================================================================
--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]