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
Pattern matching in parallel
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.