I inherited a contact table with duplicates and need to remove the dupes. The table has about 200k entries and I need to compare at least 5 fields. Is there a common practice or something in AppExchange that would do this? if not, I'm thinking of exporting the table using Data Loader, de-duping with a perl script, then importing the entire table using Data Loader.

 

Any advice on this process? I am a salesforce newbie but with a data/IT background.

 

Many thanks for advice/info.