Remove Hexadecimal Characters in Datastage

priyadharsini · Post by **priyadharsini** » Wed Feb 23, 2011 12:29 am

Try Convert() function.

ksv2584 · Post by **ksv2584** » Wed Feb 23, 2011 1:59 am

If this only for a particular column , in the transformer convert all possible hexa decimal codes using single convert function

basheer · Post by **basheer** » Wed Feb 23, 2011 4:55 am

How can we write the Hexadecimal character in a Convert Function to replace it with some other variable.

Please provide a sample syntax

ray.wurlod · Post by **ray.wurlod** » Wed Feb 23, 2011 8:36 pm

The Euro symbol is a perfectly valid character. Similarly accented characters are perfectly valid. Verify with your business whether they want valid characters to be removed. If they do, then you can use the Convert() function.