Finding lines in .txt file that contain keywords from two different set()

[MRAB]

On 2019-09-08 17:02, A S wrote:
> My problem is seemingly profound but I hope to make it sound as simplified as possible.....Let me unpack the details..:
> 
> 1. I have one folder of Excel (.xlsx) files that serve as a data dictionary.
> 
> -In Cell A1, the data source name is written in between brackets
> 
> -In Cols C:D, it contains the data field names (It could be in either col C or D in my actual Excel sheet. So I had to search both columns
> 
> -*Important: I need to know which data source the field names come from
> 
> 2. I have another folder of Text (.txt) files that I need to parse through to find these keywords.
> 
> These are the folders used for a better reference ( https://drive.google.com/open?id=1_LcceqcDhHnWW3Nrnwf5RkXPcnDfesq ). The files are found in the folder.
> 
> This is the code I have thus far...:
> 
[snip]
result1 contains a list of strings. None of the words in 'checkhere' are 
in that list. I think what you intended to do was to check whether any 
of those words are in any of the strings of result1:

     for element in checkhere:
         for r in result1:
             if element in r:
                 print(r)
                 # Found one, so stop looking for more.
                 break