Pattern matching in parallel

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
Abhijeet
Participant
Posts: 20
Joined: Wed Jul 27, 2005 1:00 am

Pattern matching in parallel

Post by Abhijeet »

How can I do a pattern match say "B[0-9]G[0-9]" in datastage ?

eg:
Description Field --> "Sale: B1G2 free"
"Sale: B2G3 free"


Thanks
Abhijeet
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 »

In which stage type? You could use an External Filter stage and use the regular expression syntax. You could use a Filter stage and use SQL WHERE clause syntax.
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
Abhijeet
Participant
Posts: 20
Joined: Wed Jul 27, 2005 1:00 am

Post by Abhijeet »

thanks ray !!! External Filter Stage is perfect for me !!!
Top
Post Reply

Return to “IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)”