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
How to replicate the REPLACE function of SQL in DataStage
Moderators: chulett, rschirm, roy
How to replicate the REPLACE function of SQL in DataStage
Thanks & Regards
KB
KB
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Code: Select all
Convert(",", "", InLink.FieldName)
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.