Find any letter in string value

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
lak4u
Participant
Posts: 43
Joined: Mon Nov 03, 2008 10:00 pm

Find any letter in string value

Post by lak4u »

Hi,

I need to Find any letter in string value

if I find @ in string value I have to put whole string in quots.
exaple: AB@DEF then "AB@DEF" else AB@DEF

but I couldn't find any FIND function which finds letter in String.

Please help


Thanks
srimitta
Premium Member
Premium Member
Posts: 187
Joined: Sun Apr 04, 2004 7:50 pm

Post by srimitta »

Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives.
By William A.Foster
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Index() can find it for you and will return the position it was found in as a bonus, but you can simply treat any non-zero return value as 'true' if you like.
-craig

"You can never have too many knives" -- Logan Nine Fingers
Sainath.Srinivasan
Participant
Posts: 3337
Joined: Mon Jan 17, 2005 4:49 am
Location: United Kingdom

Post by Sainath.Srinivasan »

Wonder what is the purpose of quoting those strings ?
Post Reply