Removing Special Characters
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 7
- Joined: Mon Mar 29, 2010 1:36 pm
- Location: WASHINGTON, DC
Removing Special Characters
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.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 7
- Joined: Mon Mar 29, 2010 1:36 pm
- Location: WASHINGTON, DC
Removing Special Characters
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.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: