A short text comparison
When the records in two tables must be compared by the #text fields, and these fields have content, similar in meaning, but different in writing, starting from simple inscriptions and different inscriptions to the conversion of words, abbreviators or inscriptions in different languages, then the application of the algorithms of the automatic #scriptions gives a good result only for inscriptions or words with different inscriptions.Favorite #Fuzzy #Lookup in #Excel with the old good algorithm #Levenstein is able to make only half of the work, and the second half of the records will not be able to compare automatically, since some matchings are able to see only dedicated in history filled with data and create these tables.Then I offer my clients a tool for a semi-automatic comparison of two tables records.And that is:
I make a form with two lists (up, down), in each of which sets are selected from several similar records, and the dedicated operator chooses by one record from each list and exactly these two records will be compared.The processing of each match and decision will take the operator from 5 to 15 seconds.And on the output you will get a table with a 100% wrongly compared record.Make an effort, spend the time and the “Wall”!
I make a form with two lists (up, down), in each of which sets are selected from several similar records, and the dedicated operator chooses by one record from each list and exactly these two records will be compared.The processing of each match and decision will take the operator from 5 to 15 seconds.And on the output you will get a table with a 100% wrongly compared record.Make an effort, spend the time and the “Wall”!