How to remove special characters from a string.
626992Sep 6 2008 — edited Oct 7 2009Hi Everybody,
I have a string, need to remove the special characters from this string.
i am using the translate but its not working. Its getting spaces in string.
for ex: string: 'abcde+fg'
I would like to remove this '+' symbol from this string.
1) Select translate('abcde+fg', '+/-', ' ') outp
from dual
o/p: abcde fg
2) Select translate('abcde-fg', '-+/', ' ') outp
from dual
o/p: abcde fg
Thanks in advance.