DSXchange

Hi All,

We have the amount value like 1000000.00 and need get the output as 100,000,0.00. Means need to seperate the amt value with Comma(,) after every three digits.

Can anybody help how to achieve this in datastage and my source column is Varchar datatype.

Thanks in advance.
RK

Really 100,000,0.00 ?

I would have thought 1,000,000.00 (Western) or 10,00,000.00 (Indian) only.

In any case, if source and target are both VarChar, then it's simply a matter of manipulating substrings and concatenating comma characters where appropriate.