Extract Only Numbers from Field 1

[maduko]

Trying to pull the numbers from a field that has these type of values.....

X999
Z12
XY512
Y21445
Z7

I know it requires something along the lines of this but I can't get it correct:


ID: Right([MemberID],IIf(IsNumeric(Mid([MemberID],2,1)),1,6))

 

[PHV]

Perhaps this ?
ID: Mid([MemberID],IIf(IsNumeric(Mid([MemberID],2,1)),2,3))

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[maduko]

Bravo!

Thank you very much.