want to remove strip Character (|| ) in output file

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
samad40
Participant
Posts: 11
Joined: Wed Jun 13, 2007 2:45 am
Location: chennai

want to remove strip Character (|| ) in output file

Post by samad40 »

Hi,

my data is like this
eg: THE VEHICLE|| NUMBER
THE|| PART SUMMARY
fINISHED VEHICLE||

actaully i need to remove the strip character || symbol and moreover its showing everywhere i mean at END and in middle.
what type of logic can we write in transformer

can you guide me on this ..
samad
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 version of the server Ereplace() function. This is precisely 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.
ravireddy25
Participant
Posts: 59
Joined: Wed Dec 31, 2008 5:49 am

Re: want to remove strip Character (|| ) in output file

Post by ravireddy25 »

Hi,
Use Convert Function in Transformer , covert it from || to '' ,it will work

Regards
Ravi
Ravi
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

... except that Convert() will also remove any single '|' characters too.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply