Show only numbers

[#1]

Hi All

I have field with values both numbers and text but I want to show only numbers from that.

How can I achieve the same.

Thanks for the help

[sasiparupudi1]

Hi

Your solution wouldnt work if the data contains special characters like & @

ex: &A1234

where as keepChar('&A1234','0123456789') would always keep only the numbers in a string

[#3]

Sorry for not explained well. I have field values like.. abc123, abc, xyz1234, xyz etc...

Need to create two fields as Number and Name

Required o/p

Number - 123,1234

Name- abc,xyz

[#4]

Sorry for not explained well. I have field values like.. abc123, abc, xyz1234, xyz etc...

Need to create two fields as Number and Name

Required o/p

Number - 123,1234

Name- abc,xyz

[sunny_talwar · Accepted solution]

Try this:

LOAD *

          KeepChar(FieldName, '0123456789') as Number

          PurgeChar(FieldName, '0123456789') as Name

Resident xyz;

[#6]

thanks sunny