DSXchange

Hello - Anyone worked on removing special characters coming from DB2 and Ms Sql Server databases? Basically the special character can be anything thats not an alphabet/number or anything thats not on the keyboard. How would I go about writing something in Datastage v8.7 Parallel that would parse an input string, accept only letters/numbers/any character found on the keyboard but convert everything else to spaces? Anything found on the keyboard such as !@#$%^....is acceptable because that can be easily removed later.

Do an exact search here for "double convert" where you provide a list of the characters you want to keep and everything else is removed from the string. One such example is here.

THANK YOU! It seems to work and I hope it captures all special characters. Only time will tell....I will come back here if I face further problems.

Is this what your customer wants? Are (some of) these special characters meaningful to them, for example accented alphabetic characters?