Removing all characters but alphanumeric

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
ds_debasis
Participant
Posts: 17
Joined: Fri May 25, 2007 11:59 am

Removing all characters but alphanumeric

Post by ds_debasis »

Removing all characters but alphanumeric (i.e. [A-Z] [a-z] [0-9]) from input strings. This string is coming from a comma separated sequential file. And I need to remove it from only one column.

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

Post by ray.wurlod »

Welcome aboard. :D

There's nothing out of the box to perform this particular task in parallel jobs. It's probably easiest to use something like an External Filter stage invoking tr sed or awk to perform the parsing.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
ds_debasis
Participant
Posts: 17
Joined: Fri May 25, 2007 11:59 am

Post by ds_debasis »

ray.wurlod wrote:Welcome aboard. :D

There's nothing out of the box to perform this particular task in parallel jobs. It's probably easiest to use something like an External Filter stage invoking tr sed ...


Thanks Ray
It was a quick reply. Let me try to filter it in unix .

Thanks again
Debasis
Post Reply