topic Re: Dupeblocker Phone Match Scenario in DemandTools

Dupeblocker Phone Match Scenario

Tasnim0923 — Thu, 29 Aug 2024 11:03:23 GMT

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?

Re: Dupeblocker Phone Match Scenario

Jamie — Fri, 30 Aug 2024 15:22:15 GMT

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.

Re: Dupeblocker Phone Match Scenario

Pugs_Validity — Tue, 03 Sep 2024 18:02:59 GMT

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.