Getting accurate Company names excluding punctuations, Inc, corp etc

[debarpanban93]

These are my 2 data sets and these are not 100% match if I use the join tool with the Name as unique. It wont match. Can anyone suggest how this be done in any other way?

[debarpanban93]

Thanks , this helps

[atcodedog05 · Accepted solution]

Happy to help : ) @debarpanban93 

If the response helps please don't forget to mark it as solution.

Cheers and have a nice day!