How to allow 11 digits phone number with VPHONE ruleset

Infosphere's Quality Product

Moderators: chulett, rschirm

Post Reply
akonda
Participant
Posts: 97
Joined: Wed Feb 28, 2007 6:15 am

How to allow 11 digits phone number with VPHONE ruleset

Post by akonda »

Hi

I am using VPHONE ruleset to standardize USA phone numbers. But It is working fine for only 10 digits phine numbers. I need to handle the data when I receive the data like
1-800-934-6489
1800-934-6489

since it has more than 10 digits, invalid Phone is generating. Any suggestions are appreciated

~Thanks
arun
stuartjvnorton
Participant
Posts: 527
Joined: Thu Apr 19, 2007 1:25 am
Location: Melbourne

Post by stuartjvnorton »

You'll have to get into the PAT file to have a proper go at this one.
You could try an input pattern override, but it would be too loose.

It's not just 11-digit numbers, but specific ranges of them that you would want to let through, excluding all others.

There will be a feature in an upcoming version that from memory should let you do close to this level of override without needing the dig into the PAT file.
rjdickson
Participant
Posts: 378
Joined: Mon Jun 16, 2003 5:28 am
Location: Chicago, USA
Contact:

Post by rjdickson »

Another option is to use the transformer before the standardize stage to strip leading 1- and 1....
Regards,
Robert
akonda
Participant
Posts: 97
Joined: Wed Feb 28, 2007 6:15 am

Post by akonda »

Yes, I handled this in transformer stage.

Thanks
arun
Post Reply