Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
KeepChar(YourString,'0123456789') as YourString
or
=KeepChar('1234@5678#9$10','0123456789')
or
Purgechar(Field,'!~@#$%^&*') as NewField
Note: Include all special characters which you want to remove