Hi,
I am looking to remove any character like ",'_',&, #, hexadecimal characters etc from a given string. That means, I would like to clean the string to have only alpha numeric characters ( 0-9 & A-Z). I know we can identify certain string contains alpha numeric characters only by using the alphanumeric function but how to identify those characters in the string and delete them in datastage. Please advise.
If this is something is not feasible in datastage, I am using sql server database. If anyone has experience doing this at sql server database level that will be great to know too..
Special Character Removal
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 376
- Joined: Sat Jan 07, 2012 12:25 pm
- Location: Piscataway
Wouldn't the convert function solve your problem?
Code: Select all
convert(colname,""'_'& #","")
Jerome
Data Integration Consultant at AWS
Connect With Me On LinkedIn
Life is really simple, but we insist on making it complicated.
Data Integration Consultant at AWS
Connect With Me On LinkedIn
Life is really simple, but we insist on making it complicated.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: