Remove Text

[Geoff Codd]

Hi there,

I have various invoice numbers

ABC111111
DE9999999
FG7777777

etc

and I would like to remove all the text from tem so I am only left with the numbers.

Any help appreciated
Thanks
Geoff

 

[maxmangion]

try using the val() function

val([fieldname])

 

[Geoff Codd]

I just tried that on the following value T21412818 and I got 0

 

[maxmangion]

oh ic, because if i am not mistaken that works only if the numbers are in front such as if it was 21412818 T.

is the field you have that code in it standard i.e. do they have the same amount of characters as being numbers because if that's the case you could try using the right() function

 

[Geoff Codd]

No they are completely random, i thought about using the right etc

 

[maxmangion]

a workaround of doing it might be the following although i believe there are better ways

go to the find / replace and start searching for the letters and replace them with spaces, then use the Trim() to get rid of the spaces