Find match between two similar string

[diegomarino]

Hi,


the title looks like an easy thing, instead the problem is that i have my list of cities (comuni.comune) and i have another list from a different source (filiali) that has the same values (filiali.des_com_ita); they are a list of italian cities.

the problem is the way accent is written, in the first case they used letters like " à ", " è " etc, in the second case the uses " a' "," e' "; in a few cases there are other differencies like "bolzano" and "bolzano-bozen" but this is not a problem, i think

to resolve the issue i made a column in "comuni" table called "comunifiliali", in which i want to insert the same city present in "Filiali" table but written in the other way (e.g. Comuni= ciriè, Filiali=cirie')
is there a way without losing my mind to do that?

i've already inserted the cities from Filiali in comuni.comunifiliali that are written the same way
thanks


sorry, i couldn't upload the file

https://hhfinanza-my.sharepoint.com/...a-GaQ?e=fTjyWh

[orange]

I can see a zip file and a Test.accdb but nothing is live to allow download.
Can you set up a regular zip file that readers can access?
I don't use oneDrive.

[diegomarino]

i think it's too big...

https://www.mediafire.com/file/zxon4.../test.zip/file

i uploaded to mediafire

[CJ_London]

As a suggestion create a new column in each table and populate with the city name replacing the accented chars with unaccented ones - then match on those

[isladogs]

There are various methods of searching for similar strings including Soundex, Simil and Levenshtein distance.
This link may be helpful Matching logic | Page 3 | Access World Forums (access-programmers.co.uk)

[orange]

Diegomarino,
You might extract some sample records and send those as a zip. 12+mb is more data than necessary for resolving the issue. Try CJ_London's suggestion as per post #4.

[diegomarino]

thank you very much all. even if i solved just replacing i see a lot of interesting stuff about serching similar value