Matching of Company name with Business name

VarunShashidhar

Hi Team,

I am working on a project with huge data,

trying to match the company name with business name.

for example, 

Company Name	Business Name	Match	Desired Result
Va run	Varun Shashidhar	FALSE	TRUE
VarunShashidhar	Var un INC	FALSE	TRUE
V a RUN	Varun Shashidhar	FALSE	TRUE
VarunShashidhar	Varun Sh ashidhar	FALSE	TRUE

MelGibson

I am hoping someone can help because this is the best I can do and would like to see how this resolved. 

I added a formula tool and created two new columns capturing the company name and business name

then I add a data cleanse tool and selected only the two newly created fields, check replace with blanks, replace with 0, Leading and trailing, tabs etc., all whitespace, Modified case to lower. 

then I add a formula tool with this formula **the field names are the newly created fields. 

IF REGEX_Match([adjusted company name], ".*" + [adjusted business name] + ".*") OR REGEX_Match([adjusted business name], ".*" + [adjusted company name] + ".*") THEN "TRUE" ELSE "FALSE" ENDIF

My output was TRUE, FALSE, TRUE, TRUE 

the false was for the business day with INC.