On Thu, 16 Jan 2003 15:12:05 -0800 "Scott, Joshua" <[EMAIL PROTECTED]> 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! What's about regular expression? If all you lines look like this you could use them. Are you familiar with them? Konrad -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]