Fuzzy match string not matching

[maleryx]

Hi.. I wanted to check on the fuzzy tool matching why is not able to match below 2 string. if necessary preprocessing is needed for the tool to match the string. 

A = '::::BXX123-ATB123'

B = '123 ATB123

[MarqueeCrew]

@maleryx,

What is the context of the matching that you're trying to perform?  The fuzzy match tool needs configuration to match strings.  Depending upon your matching needs, you might want to use alternative methods.  In your example, if you remove punctuation from the two strings, you could match with a Contains() function.  Understanding your needs and your data will help to provide you with better guidance.

Cheers,

Mark

[fmvizcaino · Accepted solution]

Hi @maleryx ,

Attached is an example showing how to do it. I did some processing removing special characters and additional spaces.

Best,

Fernando Vizcaino