Need help to parse a text file


#1

I need some help in order to parse a file, I need to get a spread of each part of this file
the problem is that the file is fix using spaces, not any character that I can use to split the file
On Notepad++ I can visualize the issue, its not using tab, its using spaces, and the amount of spaces changes during the file, not only on the last colum, this issue is present in other parts also. I need some kind of logic to evaluate this.

Any tips?


temp.zip (64.0 KB)

Ohh fix it, I just need to scream for help and my brain started working
I just use a = string to erase all cells with just spaces


#2

since all lines have the same amount of entries you can split by space and exclude empty slices. then you have a structured spread you can process further.


#3