Fuzzy Match Off by 1 Character

[gsilski]

Hello,

Does anyone know how to get a fuzzy match to work when a character from the middle of the string is missing?

String that I am given: AC7701107637

String that it should map to: AC77011007637

[gawa · Accepted solution]

hi @gsilski 

I assumed that position of a missing string is unknown, and only one string is missing. With this assumption, I prepared WF for you as attached.

My WF utilizes Regex Match instead of Fuzzy Match. To do this, combo of Generate Row and Formula works well to create all possible Regex pattern(it is a kind of Brute Force technique)

[gsilski]

Hi @gawa ,

Thanks for your response. I probably should have been more clear about what I was looking for. I want to make sure that I catch any other instances of something like this occurring. Do you have any ideas of how to get fuzzy match or something similar to work on this issue?

[gawa]

hi @gsilski 

I regret to say that I'm not sure of how your real datasets looks like, and what kind of criteria you need to configure, I cannot drill down more on this subject.

Please note that the above method using Regex should work for the most of cases.