Fuzzy match help required

Question

Hi Team,

I have thousands of names coming in different format. Sometimes they put Mr, MRs or Dr, sometimes they are without "/" or with slash or with punctuation or without punctuation. I have to make them as one name if it matches to the next one. Kindly refer tables and advise.

Appreciate your quick response.

NameResultSaif /NameSaif /NameName/SaifSaif /NameName/Saif MRSaif /NameMR Name/SaiFSaif /NameKara/TimKara/TimKara,TimKara/TimDim/Tore ShowDim/Tore ShowDimTore/ ShowDim/Tore ShowDim/Show toreDim/Tore ShowERS/COLRERS/COLRERS/COLRERS/COLERS/COL,RERS/COLNDLER/JERRY LNDLER/JERRY LNDLER/L JERRYNDLER/JERRY LNDLER/JERRYNDLER/JERRY LNDLER/L, JERRYNDLER/JERRY LNDLER/JERRY,NDLER/JERRY LNDLER/L JERRY ANDREWNDLER/JERRY LHUG/XUENHUG/XUENXUEN/HUGHUG/XUENXUEN,HUGHUG/XUENXUEN,HUG MSHUG/XUENXUEN,HUG DRHUG/XUEN

Fuzzy Match R.xlsx

mmustkee · Answer

Hi Raj,

That's look good but I do not want my original names to be changed at all in column "A". Please keep them unchanged in column "A" and result is ok but if you can add Match score also in the end in find and replace result.

Raj · Answer

are you looking for this?

If not please let me know

Basic Regex.yxmd

mmustkee · Answer

Hi Raj,

Can you please help on Column 'A' only called as "Name" forget about result. Just show match score with names in column A if they are matching to each other. Match score should be more than 80%.