VERIFIED SOLUTION i

How to ensure two records for the same apartment are seen as duplicates in Merge/Purge Plus

123 Main St APT 5S
123 Main St 5S

The records were not recognized as duplicates because there was nothing in the second record to indicate the '5S' was an apartment number, so it was parsed as part of the street address.

When a '#' was added to the second record for example-
123 Main St #5S
then the two records were seen as duplicates


 
UPDATED:  August 7, 2017