what about using the email as the macthing value ?
Thank you for your response. Using the e-mail as the match field will not really work for us. We do not have e-mail addresses for all of the contacts in our database. We will for active clients, but not necessarily for prospects or for inactive clients, who we still want to reach in the mailing campaign. Secondly, e-mail addresses change frequently, so even the e-mail addresses that we might have for prospects and inactive clients might not be accurate. Finally, most third party lists will not have e-mail addresses for all of the contacts in the lists.
There are fuzzy logic programs that easily identify inexact matches. I was hoping that a fuzzy logic program could be implemented within FP.
Thank you for your posts.
"raybaudi" had an excellent question (Thank you!), so I didn't respond until I saw your next reply.
FileMaker Pro does not have a fuzzy logic program. You can probably create some Soundex algorithms to get some information, but in the end, you would still have to look at the data.
Another option is to create a second calculation field that strips out spaces (which would handle "3M" and "3 M") and uses Substitute() functions for Bob-Robert, Bill-William, etc. (that could be a long list). I know it isn't exactly what you want, but it could help as the list grows.
Thank you so much for your reply. I will take a look at your suggestion and see whether or not we can implement Soundex algorithms.
If you can standardize your address fields you can use it for a match field. This has some advantages. For example, Robert Johnson might match the address of Mary Johnson. You then know that they live together and you don't need to mail them twice.
On the other hand, if you have a record for Robert Johnson at some address (home perhaps) and another record for Robert Johnson with a different address you may not mind mailing twice. They may be two different people with the same name or they could be the same person at home and at work. Perhaps someone will read something at work which they might discard at home so you might not mind mailing twice.
I have a similar situation, trying to match records from a 3rd party. Basically, I want to find fuzzing duplicates between 2 separate files, then merge the duplicates as single records in a new merged file/table (each record would have the matching field from both original files, plus additional fields from each of the original files).
An example would be
File A: contains full names (John Doe) and lease IDs
File B: contains full names (Jon Doe) and lead IDs
Merge File C: contains John/Jon Doe and lease ID and lead ID
**I am wondering if anyone out there has found a way to find fuzzy duplicates using Filemaker? This question was last posed in 2008, so hoping progress has been made (fingers crossed).