Dupeblocker Phone Match Scenario

[Tasnim0923]

I'm trying to identify all duplicate business phone numbers, but I'm running into an issue where duplicates aren't being detected if the phone numbers are in different formats. For example, these two numbers should be identified as duplicates, but they aren't:

+44 7392 456789 and 07392 456789

Here are the scenario rules I've tested so far:

- **Business Phone: Numeric, Alphaclean**
- **Business Phone: Exact Match, Alphaclean**
- **Business Phone: Exact Match, Alphaclean, English Fuzzy**

Despite these rules, the system isn't recognizing the numbers as duplicates when they're formatted differently. Any advice on how to handle this?

[Jamie]

You could make a calculated field using a formula that just pulls the last 10 digits (something like RIGHT (PhoneField,11)) and then find duplicates using a match in that field instead. 

[Pugs_Validity]

Hey @Tasnim0923 - Have you considered standardizing your data with Modify? Using the IntlPhoneFix formula in Modify would be able to properly format your numbers so they are easier to match using the logic.