Python Forum
Matching two files based on a spited elements
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Matching two files based on a spited elements
#1
Greetings!
I'm trying to find lines from one file in another file.
I have to do that by matching timestamp.
Lines look like this:
File 1
\\D1376\d$\logs\BBLog.100.xml,05/13/2021 00:01:23
\\D1376\d$\logs\BBLog.11.xml,05/27/2021 15:11:03
\\D1376\d$\logs\BBLog.1.xml,05/28/2021 17:02:03
\\D1376\d$\logs\BBLog.10.xml,05/27/2021 15:22:15
File 2
\\D1376\d$\logs\BBLog.100.xml,05/13/2021 00:01:23
\\D1376\d$\logs\BBLog.11.xml,05/27/2021 15:11:03
\\D1376\d$\logs\BBLog.1.xml,05/29/2021 18:04:02
\\D1376\d$\logs\BBLog.10.xml,05/29/2021 17:02:11
I have to split lines in File-1 and use split elements to match lines in File-2.
for some reason, I cannot print lines that are not in both files.

Here is a code I got:
tod1376 = 'C:\\01\\fileD1376.txt'  
yrd1376 = open ('C:\\02\\fileY1376.txt','r') 
yrd = yrd1376.readlines()

with open (tod1376,'r') as tod :
    for lntod in tod :
        lntod=lntod.strip()
        *whocares,sp_lntod = lntod.split(",")
        sp_EL1 = sp_lntod
        sp_EL1=str(sp_EL1).strip()

        for lnyrd in yrd :          
            lnyrd=lnyrd.strip()
            found = re.search(sp_EL1,lnyrd)  
            print(f" Fund matched- -{lntod}")
            if not found :
               print(f" Not Matched ++ {lntod}")
Thank you!
Reply


Messages In This Thread
Matching two files based on a spited elements - by tester_V - May-29-2021, 10:00 PM

Possibly Related Threads…
Thread Author Replies Views Last Post
  Copy Paste excel files based on the first letters of the file name Viento 2 478 Feb-07-2024, 12:24 PM
Last Post: Viento
  unable to remove all elements from list based on a condition sg_python 3 486 Jan-27-2024, 04:03 PM
Last Post: deanhystad
  Move Files based on partial Match mohamedsalih12 2 868 Sep-20-2023, 07:38 PM
Last Post: snippsat
  Making a question answering chatbot based on the files I upload into python. Joejones 1 1,285 May-19-2023, 03:09 PM
Last Post: deanhystad
  ValueError: Length mismatch: Expected axis has 8 elements, new values have 1 elements ilknurg 1 5,228 May-17-2022, 11:38 AM
Last Post: Larz60+
  Replace elements of array with elements from another array based on a third array Cola_Reb 6 1,961 May-13-2022, 06:06 PM
Last Post: deanhystad
Question Change elements of array based on position of input data Cola_Reb 6 2,185 May-13-2022, 12:57 PM
Last Post: Cola_Reb
  select Eof extension files based on text list of filenames with if condition RolanRoll 1 1,555 Apr-04-2022, 09:29 PM
Last Post: Larz60+
  Finding files matching pattern GrahamL 1 1,326 Jan-14-2022, 01:16 PM
Last Post: DeaD_EyE
  Compare filename with folder name and copy matching files into a particular folder shantanu97 2 4,560 Dec-18-2021, 09:32 PM
Last Post: Larz60+

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020