Re: Unstring by more than one delimiter

[Glenn Coulter <Glenn.Coulter@US.RANDSTAD.COM>]

If all the fields are delimited by both the " and the , why not use the
translate function to strip all the " characters from your strings after you
unstring using the , character.

Two steps but it would work..
Glenn

-----Original Message-----
From: Cadenas, Maria (MT) [mailto:MCadenas@DOW.COM]
Sent: Tuesday, April 10, 2001 3:57 PM
To: SQR-USERS@list.iex.net
Subject: Unstring by more than one delimiter


my input data looks the following way:

"Mark","Jones","100 Spruce",...

so that the values are in quotes and separated by commas.

Is there a way to Unstring this data into substrings with values without
quotes or commas?