I am building an application that compares data from two vendors. They each maintain a table that has common fields in addition to fields unique to the vendor.
What I want to do is compare the data in the common fields. For instance, each table has a part description. In a perfect world, I would create a calc [PartDescr1]=[PartDescr2] and look for instances where they aren’t equal. However, one vendor uses the term ‘First Aid Kit’ while the other uses the term ‘Kit – First Aid’. I plan on setting up a simple table to bridge obvious gaps like this that converts one term to match with the other.
However, I would also like to build a feature like they use in the search engines that will look at one phrase and tell you the % that matches the other phrase. For instance, ‘Quarter Panel’ and ‘Fender Panel’ would be a 50% match and ‘Front left hubcap’ and ‘Front driver side hubcap’ would also be 50% since only 2 of the 4 words from phrase two are present in phrase one (I understand we have to pick one side to run the calc)
If someone has something that might work, I would really appreciate it. If this seems like a crazy request, feel free to let me know that too.
Thanks!!
Dashiell
