Filter tool with wildcard

[cmdaglish]

Hi, 

I'm trying to compare a list of names from two different datasets to determine if they are the same person. I've done a Text to Columns using a space as the delimiter on the Source data. 

The Fuzzy Match tool is proving too inaccurate for the case below and therefore I want to use a filter tool to remove them from my data and class them as the same person. 

Source1	Source2	Target
John	Doe	J A Doe

Is there a way to write something similar to 

Contains([Target], Left([Source1],1) + " " + *Wildcard* + " " + [Source2])

Any help would be appreciated. 

Thanks!

[atcodedog05 · Accepted solution]

Hi @cmdaglish 

One of the ways is to use starts with and ends with.

Workflow:

Hope this helps : )

[atcodedog05 · Accepted solution]

Hi @cmdaglish 

Another method is by using REGEX_Match.

Workflow:

Hope this helps : )

[cmdaglish]

@atcodedog05 amazing, thanks!

[atcodedog05]

Happy to help : ) @cmdaglish 

Cheers and have a nice day!