7.2.2 Contact Mobile Duplicates in Alternate Channel

This page contains documentation on analysis, proposed steps to de-dupe phone numbers in Alternate Channels where the phone number already exists in ‘Mobilephone’ filed on Contact object.

Approach:

Phone numbers linked to contact records were isolated and cleaned to remove -

• Any special characters, blank spaces etc.,

• +61 was replaced with 0

• 00s & 000s were replace with 0

• 00011 was replace with blank

Exclusions: Contact Type - ‘Student’

If the cleaned phone data in Mobilephone field exist in Alternate Channel, then delete the Alternate Channel Phone record.