Hi
Can anybody guide me in this regard?
How to do pattern matching in DS PX.
Example you have to move all cities which are having "MI" anywhere in their name. i.e %MI%
Substr can work if we are sure where "MI" can occur in the incoming string.
Count will also not work in this case because it will populate both MI% and %MI%.
Any other way of doing it.
Thanks and Regards
Ashwin
Pattern Matching in DS PX
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 3593
- Joined: Thu Jan 23, 2003 5:25 pm
- Location: Australia, Melbourne
- Contact:
There is the Index function which finds the starting character position of a substring. It can be used in a parallel transformer. Not sure if it will work in a filter stage. Constraint: Index(input.mycol, "MI") > 0
Certus Solutions
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn:Vincent McBurney LinkedIn
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn:Vincent McBurney LinkedIn