A quick and dirty solution - do replacestring first, to replace "," with say | and then tokenize on |.
A. > -----Original Message----- > From: Jon Grieve [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, September 04, 2002 10:32 AM > To: Multiple recipients of list witango-talk > Subject: Witango-Talk: Parse CVS file > > > All, > > I'm trying to parse a comma-delimited string, which is > nothing unusual... > however, the problem I'm seeing is that I can't use <@TOKENIZE ... > CHARS=","> because some of the string data contains commas. > Every field is > enclosed in quotes. > > An example might look like: > > "1","Some","Text","that, perhaps","contains commas" > > So, I see I'm going to have to manually trawl the string > looking for the > quotes and breaking apart to get individual fields. Again, that is > relatively straight-forward, but I envisage some messy code. > Has anyone > already done this, and can share some code snippets? > > Ta, > > Jon > ______________________________________________________________ > __________ > TO UNSUBSCRIBE: send a plain text/US ASCII email to > [EMAIL PROTECTED] > with unsubscribe witango-talk in the message body > ________________________________________________________________________ TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] with unsubscribe witango-talk in the message body
