DSXchange

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

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?

1) I want to make the 800,888 numbers as invalid
2) Yes, your understanding is correct.

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.