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

[Kushal_Chawda]

Try,

Keepchar(Name,'0123456789')

[sunny_talwar]

Use this as your expression: =If(IsNum(Field), Field)

[#4]

Hi ,

I am getting blank values while I am using this

[#5]

Hi,

It works. let me test it completely

[awhitfield]

Can you post some sample data / script details?

Andy

[sunny_talwar]

I think Kush141087‌ understood your requirement better than I did.

[Kushal_Chawda]

hey sunindia i think question was not structured well.Field values have both numbers and text means you understood correctly. May be i did not understand properly but may be i will lucky

[sgrice]

ALT(Field)

[krishna20]

HI,

Try this

=purgeChar(Data,'()ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz')

Find the sample also.