Replacing special characters by null
Posted
by madheena
on Stack Overflow
See other posts from Stack Overflow
or by madheena
Published on 2010-04-29T06:31:12Z
Indexed on
2010/04/29
6:37 UTC
Read the original article
Hit count: 180
informatica
Hi,
Is there any function to replace the special characters by null in informatica
if we used replacestr function, i think we should specify all special characters
as follows replacestr(input,'!','~','@','#','$','%','^','&','*',null)
But we dont know what are teh special characters will be coming as input.
can u please let me know that which function will be suitable.
© Stack Overflow or respective owner