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
Comma seperation in the amount value
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.