Hello community!
I am looking to see if someone can help me with a project I am trying to create which converts a .txt file into a simple excel file with 7 columns of information. I am running into an issue where the project will sometimes pull rows from the .txt file that I thought my other preparation tools were filtering for. This file changes month to month in output length but is pretty consistent but I noticed my project might work for one month but then pull rows it shouldn't for other months.
Want to see if anyone can help me better my project or let me know what from my project is hindering it from outputting exactly what I need.
I have attached the test text file, the project I'm using, and a file with how the project should look if outputted correctly.
(Also if at all possible, is there a way to not have to delimit the text file every time? When I input the text file I always have to manually input the delimited lines so my project knows what columns I want. Is there a better way of doing this where I can just input a new months file and the project already know what columns I need?)
Thank you for any help!
