Re: string manipulation

[Savage Doug - dosava <Doug.Savage@ACXIOM.COM>]

Where is it coming from(Is this the result of a select, returned from
reading a file, etc??)
is '1,2W2,3W3,5W2' a value in and of itself, or is '1,(thru),3W3' one value?


-----Original Message-----
From: Jim Wyant [mailto:wyantj@YAHOO.COM]
Sent: Tuesday, February 05, 2002 1:40 PM
To: SQR-USERS@list.iex.net
Subject: string manipulation


Group,

I have strings of varying length. They take the form of,

1,2W2,3W3,5W2
1,3W1,3W2,3W3,5W1
2W2,3W3

I need them in the form of,

'1','2W2','3W3','5W2'
'1','3W1','3W2','3W3','5W1'
'2W2','3W3'

I'm trying to avoid writing a while end-while loop and TRANSLATE seems
to be unable to exchange a , for ',' . I'll write a while loop if I
have to and use INSTR and SUBSTR, but I was wondering if anyone has had
to do something similar and come up with a clever solution.

Thanks, Jim



__________________________________________________
Do You Yahoo!?
Send FREE Valentine eCards with Yahoo! Greetings!
http://greetings.yahoo.com


********************************************************************

The information contained in this communication is
confidential, is intended only for the use of the recipient
named above, and may be legally privileged.
If the reader of this message is not the intended
recipient, you are hereby notified that any dissemination,
distribution, or copying of this communication is strictly
prohibited.
If you have received this communication in error,
please re-send this communication to the sender and
delete the original message or any copy of it from your
computer system. Thank You.