Hi,
I am new to pattern matching utility in quality stage. Any help would be greatly appreciated
I am using standardization stage to clean up phone numbers. I am utilizing VPHONE.SET for cleansing the data.
I would like to add few more conditions to the existing VPHONE.SET using overrides Window.
Below listed are few examples. Could you help me pattern matching. If I could help me with one or two, I could figure out the remaining
Numbers starting with 800 ex: 800-859-9854
Numbers starting with 888 ex: 888-859-9854
Numbers which has six repetitive numbers : ex: 2511111109
Thanks,
Sunil
Pattern matching using overrides - standardization stage
-
- Participant
- Posts: 2
- Joined: Mon Oct 17, 2011 12:51 pm
-
- Participant
- Posts: 2
- Joined: Mon Oct 17, 2011 12:51 pm
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
And what do you want to do when invalid numbers are found? For example you could populate the InvalidData field, and possibly InvalidPattern if this were pertinent.
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.