Page 1 of 1

Posted: Wed Feb 23, 2011 12:29 am
by priyadharsini
Try Convert() function.

Posted: Wed Feb 23, 2011 1:59 am
by ksv2584
If this only for a particular column , in the transformer convert all possible hexa decimal codes using single convert function

Posted: Wed Feb 23, 2011 4:55 am
by basheer
How can we write the Hexadecimal character in a Convert Function to replace it with some other variable.

Please provide a sample syntax

Posted: Wed Feb 23, 2011 8:36 pm
by ray.wurlod
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.