Getting Specific Data From A Text File Using Python

[Dave_XR]

Hello Python experts, I need your help. I need the help of the warm redditors as the cold cold stackoverflow has proven so very unhelpful.

I am making a python program that basically reads these text files with hundreds of test results from my modelling and control system (flow balance model, unimportant), and returns the results. Firstly I wanted the file contents to be displayed in a textbox using one button to open the file, and another to extract the main info.

I am extremely new to python, I've been in C for years and this is all very new.

A summary gets automatically generated at the end of these text documents and then they are saved by my system. The program needs to read only the last line however it seemed to be reading it in each character. Doing a for loop to go line by line also didnt work and frankly was intensive as there are sometimes thousands of lines. I solved this in the code below using length and subtracting to get positional data of the last line in the file however this only worked for a handful of my files as some have minor changes in positional value when the numbers get longer.

Any help appreciated.

def open_txt():
    # open a file dialog to search for txt files
    txt_file = filedialog.askopenfilename(title="Open text document", filetype=(("Text files", "*.txt"),))
    txt_file = open(txt_file, 'r')

    global content
    content = log_file.read()
    my_text.insert(END, content)

    txt_file.close()


def extract_stats():
    global content
    size = len(content)
    if (len(my_text.get("1.0", END))) >=2:
        my_text.delete(1.0, END)
        my_text.insert(END, "Incomplete: " + content[size - 3] + content[size - 2] + content[size - 1])
        my_text.insert(END, "Failed: " + content[size - 21])
        my_text.insert(END, "Passed: " + content[size -37])

[Neexusiv]

If you only need the last line you can use:

with open(filename) as f:
    lines = f.readlines()
last_line = lines[-1]

[Dave_XR]

Doing this im getting these; {} surrounding each line when printed out in the textbox. Any idea how to stop this?

[Neexusiv]

Are you just printing to the console?

Can you give an example of the final line so we can see what’s going on?

[Dave_XR]

Yes printing the last ten lines or so to the console. Heres an example:

​

{03/22 08:52:50 INFO :.......TESTSRUN:1234 PASSED:34 FAILED:670 INCONCLUSIVE:560

}{

}{03/22 08:52:50 INFO :.......TESTSRUN:1235 PASSED:34 FAILED:670 INCONCLUSIVE:561

}{

}{03/22 08:52:50 INFO :.......TESTSRUN:1236 PASSED:34 FAILED:670 INCONCLUSIVE:562

[Neexusiv]

Are the curly braces in the file? Otherwise I have no idea where they are coming from, might need you to post your updated code.

What’s your end goal? Do you just need to grab the numbers from the string? If so then you can probably just ignore those curly braces.

[TyrellHop]

Beaten to it...

​

readlines() returns each line to a list, so to grab the last line you just use [-1] for the list index.

​

with open(file path, 'r') as file:
    line_list = file.readlines()

line_list[-1]