sprecial character in the input column

boppanakrishna · Post by **boppanakrishna** » Mon Oct 09, 2006 6:21 am

hi all,
I want to find out the special characters in my Column in Datastage.i have written query in DB2 it's working fine but i want to know how it is going to be done in the Datastage

Scenario: suppose my input "dfg;uiko=ikey" i want to trim all the special characters and i want to have out put as "dfguikoikey" at one step, i have done the same with multiple steps by using "Ereplace" and "Filed" Functions

ray.wurlod · Post by **ray.wurlod** » Mon Oct 09, 2006 3:50 pm

Are you sure this is a parallel job? There is no Ereplace() function available in parallel Transformer stage.

If it's a server job or a BASIC Transformer stage you can use the LETTERS Transform (which is defined as Oconv(Arg1,"MCA")) - this preserves only alphabetic characters. However, if you have alphabetic and numeric characters as non-special, you need a slightly different approach. Search the forum for "alphanumeric" - this discussion has been had fairly recently.

If you know what the special characters are you can use the Convert() function to remove them. For example

Code: Select all

 Convert(";=", "", InLink.TheString)

ambasta · Post by **ambasta** » Wed Oct 11, 2006 2:40 pm

Are you able to find the solution.if yes! please let us know how we can do that???