I need to replace non standard characters in a string with blanks.
I can easily find them using translate:
'ABCDEFGHIJKLMNOPQRSTUVWXYZ1234567890') > ' '
But I can't seem to hit on the correct combination of functions (translate,replace,position)
to find a way to blank anything in the string that is not included in the list of standard characters (ABC...)
I need to turn '$ABC%DEF*' into ' ABC DEF '
Can anyone help?
Pinned topic Replace non standard characters with blanks
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2012-08-08T13:46:06Z at 2012-08-08T13:46:06Z by SystemAdmin