DSXchange

Posted: **Wed Oct 21, 2009 9:52 pm**

Hi,
I have a feild in which the data is like 99,99,999.123
now i want to remove these commas and i want to make it as 9999999.123
Can any one please guide me...

Thanks & Regards
KB

Posted: **Wed Oct 21, 2009 10:31 pm**

Code: Select all

Convert(",",  "", InLink.FieldName)

in a Transformer stage

Posted: **Thu Oct 22, 2009 1:41 am**

You can also use trim function to trim the string "," in transformer stage

DSXchange

How to replicate the REPLACE function of SQL in DataStage

How to replicate the REPLACE function of SQL in DataStage