extracting only numers from a Text

[#1]

I need help to get the number from a Text .

For eg .

If Text is "23 T 34,L" , digits could appear randomly in the Text

So if extracted The value should be in the form of Number .

2334 ..

Any idea to solve it .

[#2 · Accepted solution]

Hi,

Try using the below code.

=purgechar(upper(Fieldname),'ABCDEFGHIJKLMNOPQRSTUVWXYZ')

- Sridhar

[#3]

I already Solved it .Thanks for the help.