Fuzzy matching a name within a paragraph

Question

Hello Everyone,

I need some assistance with a fuzzy matching I am trying to do.

I've done some standard fuzzy matches on name and addresses but am struggling to do a match between two files based on a 'name' value separated by a vertical bar.

1st file: Names

2nd file: Information containing the 'Name' but is separated by vertical bars.

I am trying to do a fuzzy match to produce a match score based off the 'name' in both files. In the second file, I bolded 'Cisco' and 'Tripex'.

One of the files has 5 million rows...

Any help is appreciated!

mzsweetumz · Answer

Hi @ArtApa , @atcodedog05

Something like this.

I have done other fuzzy matches for different match types and will eventually union it all into one big spreadsheet.

ArtApa · Answer

Hi @mzsweetumz - Can you please show how a desired output should look like?

mzsweetumz · Answer

Hi @atcodedog05 and @ArtApa ,

Thank you! The find and replace works wonders and is a really cool tool that I did not know about.

However, I am still stumped - as I didn't give enough background info on my two files. I am trying to match two files to find which 'responses' has the business 'name' in it.

The file with the business 'names' has 5 million rows... and the file with the business 'responses' only has 150 rows.

I am trying to match the business name and business responses associated with a person (their name), but that's not something I can join on.

This output looks right, however, I don't think it is as it's not linked to the same person.

any help is appreciated!