Re: Unstring by more than one delimiter

[Alan Heslop <Alan.Heslop@PACONSULTING.COM>]

The following code will do it for you.  You can have as many output
variables in the unstring command as you want.  It can be more than number
of substrings returned.

let $doublequote = '"'
let $space = ''
let $input = '"Mark","Jones","100 Spruce"'
let $stripped = translate($input,$doublequote,$space)    !strip input of "
unstring $stripped by ',' into $var1 $var2 $var3 $var4.......    !seperate
input by ,


Alan

-----Original Message-----
From: Cadenas, Maria (MT) [mailto:MCadenas@DOW.COM]
Sent: 10 April 2001 20:57
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?