Re: Unstringing characters

["Sangameswaran Subathra (KAWP 12)" <subathra.sangameswaran@CSFS.COM>]

Hi,
You can use the unstring function in sqr.
eg.
unstring $emp-info by ' / ' into $name $ID

regards,
Subathra Sangameswaran
CREDIT SUISSE FINANCIAL SERVICES
Technology and Operations
Data Warehouse and MIS  / KAWP 12
Schärenmoosstrasse 80
P.O. Box 600
CH 8070 Zürich
Phone +41 1 334 59 17
Fax:      +41 1 334 50 60
e-mail: subathra.sangameswaran@csfs.com
Internet: www.csfs.com



-----Original Message-----
From: Erik Siradas [mailto:erik_siradas@HOTMAIL.COM]
Sent: Monday, February 04, 2002 2:48 PM
To: SQR-USERS@list.iex.net
Subject: Unstringing characters


Hey All!!

I have a problem that hopefuly someone can help me with.  I have to unstring
a field, breaking at a character.  This is what I mean. I have a field
cominging in as 'Employee/1728347'.  I need to draw the number after the '/'
to a report.  The character length before the '/' is always going to be
different so I need something that will go through the string and get all
characters after the '/'.  Thanks

_________________________________________________________________
Chat with friends online, try MSN Messenger: http://messenger.msn.com