special characters removing

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
iamnagus
Participant
Posts: 48
Joined: Wed Sep 29, 2004 1:16 am

special characters removing

Post by iamnagus »

Hi All...

i have input as

name
%$&*BANGALORE)(_+*^

I WANTO TO GET OUT PUT AS "BANGALORE" ONLY

Can any one try for this..

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

Post by ray.wurlod »

Please post questions in the correct forum. Server job answers may not be helpful for parallel job questions, and it helps future searchers if the questions are in the correct forum.

A server job answer is to use Oconv() with "MCA" as the conversion specification. But this is not applicable in the parallel 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.
Post Reply