Finding duplicates that are not exact duplicates
I am using FM 11. I am importing data into my database from an excel spreadsheet and I need an easy way to check for duplicates. My problem is that the duplicates are not always exact. As an example, I am importing businesses and business locations. The name of one business is Joe's Chop Shop. However, I already have Joe's shop in my database, but it's just called Joe's Shop. I have many similar cases to deal with and I would rather not perform finds individually. Is there a script I can use that will call up all of the similar records upon the completion of the import or am I dreaming?
I don't know much about script writing or finds for that matter...simple words please!
Thanks for the help.