in reply to Re^2: compare 2 CSV files for string return lines in both if match
in thread compare 2 CSV files for string return lines in both if match

It looks quite messy. How are you supposed to identify the names and company names that you want to compare?
  • Comment on Re^3: compare 2 CSV files for string return lines in both if match

Replies are listed 'Best First'.
Re^4: compare 2 CSV files for string return lines in both if match
by Anonymous Monk on Feb 02, 2018 at 21:07 UTC

    In this example I would be hoping to match "Dr. Toy Story" in csv1 to "Dr. Toy Story" in csv2. This example doesn't contain an institute match. In need to compare each string between each set of comas to each string, again in between commas as it's csv in the second file. At match I'd like to return the line containing the match for each and write it to a new file.