DSXchange

Posted: **Mon Feb 27, 2006 12:59 am**

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

Posted: **Mon Feb 27, 2006 10:10 am**

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.

Posted: **Mon Feb 27, 2006 10:43 pm**

thanks ray !!! External Filter Stage is perfect for me !!!

DSXchange

Pattern matching in parallel

Pattern matching in parallel