Pattern matching using overrides - standardization stage

Infosphere's Quality Product

Moderators: chulett, rschirm

Post Reply
sunils2020
Participant
Posts: 2
Joined: Mon Oct 17, 2011 12:51 pm

Pattern matching using overrides - standardization stage

Post by sunils2020 »

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
sunil
rjdickson
Participant
Posts: 378
Joined: Mon Jun 16, 2003 5:28 am
Location: Chicago, USA
Contact:

Post by rjdickson »

Hi,

What do you want to do with the 800 numbers when you see them?

For the six numbers, do you mean six of the same number in a row anywhere in the phone number?
Regards,
Robert
sunils2020
Participant
Posts: 2
Joined: Mon Oct 17, 2011 12:51 pm

Post by sunils2020 »

1) I want to make the 800,888 numbers as invalid
2) Yes, your understanding is correct.
sunil
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

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.
Post Reply