How to Identify Repeating Data Entries when the Repeated Entries are Spelled or Constructed Differently
For R: Have a look and the stringr package. I would use for example the str_detect() function as follows: str_detect(column_of_different_names,&quot;DOE|company_name&quot;). This will return TRUE for each string that includes &quot;DOE&quot; or the company name in &quot;company_name&quot;.