How to replicate the REPLACE function of SQL in DataStage

A forum for discussing DataStage<sup>®</sup> basics. If you're not sure where your question goes, start here.

Moderators: chulett, rschirm, roy

Post Reply
kumarkb
Premium Member
Premium Member
Posts: 10
Joined: Fri Oct 09, 2009 2:08 am
Location: india

How to replicate the REPLACE function of SQL in DataStage

Post by kumarkb »

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
Thanks & Regards
KB
Top
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Contact ray.wurlod

Post by ray.wurlod »

Code: Select all

Convert(",",  "", InLink.FieldName)
in a Transformer stage
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Top
gssr
Participant
Posts: 243
Joined: Fri Jan 09, 2009 12:51 am
Location: India

Post by gssr »

You can also use trim function to trim the string "," in transformer stage
RAJ
Top
Post Reply

Return to “General”