Page 1 of 1
Find numeric characters in a string
Posted: Thu Nov 25, 2010 6:48 am
by dr.murthy
Hi,
How to find all characters in a string are numeric???
Any suggestions??
Posted: Thu Nov 25, 2010 7:35 am
by Ravi.K
If Convert('1234567890 ','',MyString)='' Then "Numeric" Else "AlphaNumeric"
Posted: Thu Nov 25, 2010 1:23 pm
by ray.wurlod
Server job or parallel job?
Posted: Thu Nov 25, 2010 8:02 pm
by dr.murthy
Server job
Posted: Thu Nov 25, 2010 10:39 pm
by Ravi.K
In Server Also "Convert" function is there. There are couple of functions available.
If Convert('1234567890 ','',MyString)='' Then "Numeric" Else "NON Numeric"
Or
If Num(MyString)=1 Then "Numeric" Else "Non Numeric"
Posted: Thu Nov 25, 2010 11:57 pm
by ray.wurlod