Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Fuzzy logic
Message
From
22/07/2011 11:46:16
 
 
To
22/07/2011 11:33:56
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Miscellaneous
Thread ID:
01518913
Message ID:
01518914
Views:
97
>A coworker wants me to build a routine that will search a dbf for duplicate addresses. A simple task if we were looking for an exact match. However he wants me to use "fuzzy" logic so that the match doesn't have to be exact, just "pretty close". I haven't a clue how to go about this. Is there a routine around that I could use as a sample to get started?

You need to establish a pointing system based on various criteria in matching related items. It took us several months to fine tune such routine in the earlier '90s for a project I worked on. Then, based on corelation with the data and the point system, you can decide the percentage of acceptance which would then be consider a duplicate. If you fine tune that a lot, you can obtain a 99.5% percentage of efficacity on those which will be removed.

This is usually applied on mailing list procedures.
Michel Fournier
Level Extreme Inc.
Designer, architect, owner of the Level Extreme Platform
Subscribe to the site at https://www.levelextreme.com/Home/DataEntry?Activator=55&NoStore=303
Subscription benefits https://www.levelextreme.com/Home/ViewPage?Activator=7&ID=52
Previous
Reply
Map
View

Click here to load this message in the networking platform