CODEWITHSUNDEEP
python
Ben Keez
Ben Keez

Reputation: 57

Reading from and printing records from a file

I need to be able to read from a file and print records if a variable entered is pre-existent in the file. I have tried to open the file as 'f' however that would only read the first line in the file, heres my code:

        problem = input("Please select from one of these: sink, faucet, toilet, shower, heater, other: \n")
        temporaryFile = open("plumberInfo.txt" , "r")
        for row in temporaryFile:
            record = row.split(",")
            if record[6] == problem:
                Pforename = record[1]
                Psurname = record[2]
                Pfee = record[3]
                Pexperience = record[4]
                Prate = record[5]
                print("You have selected", Pforename, Psurname, "they have", Pexperience , "years of experience and they specialise in", problem, "\n")
            else: 
                print("Invalid input")
                plumberSearch() #This part isn't relevant

Also below I have attached some contents of the file:

743,Auryn,Smith,42.00,6,44.50,faucet,extra
583,Michael,Lanlow,25.00,8,75.00,sink,extra
731,Hanna,Taylor,42.00,14,55.00,heater,extra
981,Tomie,Agen,32.00,6,44.50,toilet,extra

I don't understand the problem as it worked fine for when I was searching by the ID ([record0]). There is no traceback error, it just states invalid input which means record[6] != problem, however it is equal.

Upvotes: 0

Views: 341

Answers (1)

archangel
archangel

Reputation: 110

When I try the code on my machine, printing record shows me that the last item contains a new line character at the end. Thus when you search for sink, you're essentially doing the search sink == sink\n, hence why you get invalid input.

Reading in the file also reads in the new line, and you need to be aware. You would need to remove it before doing the comparison.

Upvotes: 1

Related Questions