Comma seperation in the amount value

ravij · Post by **ravij** » Thu Aug 25, 2011 1:31 am

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

ray.wurlod · Post by **ray.wurlod** » Thu Aug 25, 2011 3:39 am

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.