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: 186

Filed under:

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

Related posts about informatica