Matching Names between 2 data files

[SR]

HI All,

I have 2 data files where one of the common column is Company Name. I want to do a join on company name but it needs to be a like type join..so all variations of the name are matches.

File 1 :

Company	Country
XYZ	UK
ABC	Brazil

File 2:

company name	loc	add	url
XYZ	UK	123	www.xyz.com
XYZ Ltd	Russia	111	www.xyz.com
ABC Corp	US	11	www.abc.com

Desired output:

Company	Company name	Loc	Add	URl
XYZ	XYZ	UK
XYZ	XYZ Ltd	Russia
ABC	ABC Corp	US

What would be the best way to achieve this type of join.

Thanks

Sam

[danrh · Accepted solution]

The Find Replace tool has some functionality that can handle this kind of thing:

When you select "Append Field(s) to Record", it acts more or less like a like-join.  Give it a look, see if it meets your needs.