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
--
https://mail.python.org/mailman/listinfo/python-list