String help

[#1]

Hi,

I have scenario pls help

how to remove special characters in below string.

1234@5678#9$10

I tried with subfield function.but didn't work 

Any suggestions?

[MK_QSL]

KeepChar(YourString,'0123456789') as YourString

or

=KeepChar('1234@5678#9$10','0123456789')

[Kushal_Chawda]

or

Purgechar(Field,'!~@#$%^&*') as NewField

Note: Include all special characters which you want to remove