Pattern Matching in DS PX

ashwin141 · Post by **ashwin141** » Thu Sep 08, 2005 12:29 am

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

ray.wurlod · Post by **ray.wurlod** » Thu Sep 08, 2005 1:38 am

BASIC Transformer stage?

vmcburney · Post by **vmcburney** » Thu Sep 08, 2005 5:22 pm

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

ashwin141 · Post by **ashwin141** » Thu Sep 08, 2005 11:46 pm

Thanks Vincent. I got the solution by using count and If Else statement.

Regards
Ashwin