Page 1 of 1

Find any letter in string value

Posted: Thu Jul 23, 2009 11:46 am
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

Posted: Thu Jul 23, 2009 12:05 pm
by srimitta

Posted: Thu Jul 23, 2009 1:24 pm
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.

Posted: Thu Jul 23, 2009 1:49 pm
by Sainath.Srinivasan
Wonder what is the purpose of quoting those strings ?