Python Forum
failing to print not matched lines from second file
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
failing to print not matched lines from second file
#2
First of all, the "l_few" (file with fewer lines) is file_1 according to the text, so I swapped the file names to change as little as possible in your original program.
Then I came up with this, hope it helps, note that I didn't change much, just enough to make it print what you need:
with open ('file_2','r') as l_few :
    f2=l_few.readlines()
sp23 = [s.split(',')[3].strip() for s in f2] # collect all the terms you need to compare
with open ('file_1','r') as f1:          
    for lf1 in f1:
        lf1=lf1.strip()
        sp1 = lf1.split(",")
        if sp1[3] in sp23:
            pass # here we have a match so print nothing
            # spL2=lf2.split(",")
            #print (" File 2 Line matched --> "+lf2)
            #break
        else :
            print (lf1) # print the non-matching line
            #break
Output:
Output:
03/28/2021,P,16,LINE1 03/28/2021,P,9,LINE3 03/28/2021,P,8,LINE5 03/28/2021,S,95,LINE6 03/28/2021,S,1,LINE7 03/28/2021,P,46,LINE8
So the error you made was to compare first with one term then with the other so, for each line you had at least one mismatch.
Further simplification:
with open ('file_2','r') as l_few :
    f2=l_few.readlines()
sp23 = [s.split(',')[3].strip() for s in f2] # collect all the terms you need to compare
with open ('file_1','r') as f1:          
    for lf1 in f1:
        lf1=lf1.strip()
        sp1 = lf1.split(",")
        if sp1[3] not in sp23:
            print (lf1) # print the non-matching line
tester_V likes this post
Reply


Messages In This Thread
RE: failing to print not matched lines from second file - by Serafim - Mar-29-2021, 11:27 AM

Possibly Related Threads…
Thread Author Replies Views Last Post
  Failing to connect by 'net use' tester_V 1 187 Apr-20-2024, 06:31 AM
Last Post: tester_V
  Failing to print sorted files tester_V 4 1,280 Nov-12-2022, 06:49 PM
Last Post: tester_V
  Saving the print result in a text file Calli 8 1,823 Sep-25-2022, 06:38 PM
Last Post: snippsat
  Failing reading a file and cannot exit it... tester_V 8 1,838 Aug-19-2022, 10:27 PM
Last Post: tester_V
  Failing regex tester_V 3 1,188 Aug-16-2022, 03:53 PM
Last Post: deanhystad
  Delete multiple lines from txt file Lky 6 2,320 Jul-10-2022, 12:09 PM
Last Post: jefsummers
  Print to a New Line when Appending File DaveG 0 1,232 Mar-30-2022, 04:14 AM
Last Post: DaveG
  Extracting Specific Lines from text file based on content. jokerfmj 8 3,056 Mar-28-2022, 03:38 PM
Last Post: snippsat
Sad Want to Save Print output in csv file Rasedul 5 10,999 Jan-11-2022, 07:04 PM
Last Post: snippsat
  Convert legacy print file to XLSX file davidm 1 1,819 Oct-17-2021, 05:08 AM
Last Post: davidm

Forum Jump:

User Panel Messages

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