Replacing '&' with '&'

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
bireswar.goswami
Participant
Posts: 33
Joined: Wed Sep 03, 2008 5:48 am
Location: Bangalore

Replacing '&' with '&'

Post by bireswar.goswami »

I need to replace '&' with '&' without using xml stage in transformer. Would be great if someone can plase help me on this.
Thanks,
Bireswar
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Search DSXchange for a parallel equivalent of the server routine Ereplace. It's exactly what you need.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
sridinesh2009
Participant
Posts: 14
Joined: Wed Nov 11, 2009 4:52 am
Location: New York

Post by sridinesh2009 »

Convert function can be used...
convert('&','&',DsLink)
Dinesh.D
priyadarshikunal
Premium Member
Premium Member
Posts: 1735
Joined: Thu Mar 01, 2007 5:44 am
Location: Troy, MI

Post by priyadarshikunal »

sridinesh2009 wrote:Convert function can be used...
convert('&','&',DsLink)
no, convert function can't be used in this case as it replaces one character with other. Read the manual for more details.

As Ray said there is a parallel version of ereplace posted a while ago by dsguru2b called pxereplace, which can be used in this case.
Priyadarshi Kunal

Genius may have its limitations, but stupidity is not thus handicapped. :wink:
Post Reply