Special character conversion to blank

Rajee · Post by **Rajee** » Fri Oct 09, 2009 6:19 am

Hi All,

I have a problem.
I have a string column from source file which can consist of any type of character.
Any character beyond [A-Z], [a-z] and [0-9] will be considered special character. In case there are any special character we need to replace them with blank.
There is no specified set of special character.
Can anyone help me to resolve the same.

Rajee · Post by **Rajee** » Fri Oct 09, 2009 6:21 am

For example incase the source is 5A@~24

output should be : 5A24

chulett · Post by **chulett** » Fri Oct 09, 2009 6:41 am

Try extending the logic noted here:

viewtopic.php?t=129328