There is a txt, with chaos data, which actually is a diagram, i want to map the value into different cells of excel.
the txt is
the excel looks like this:
The excel format will be input manually, i need to capture the cell content. But i don’t know how to capture separate words in one line of txt, such as “Unlisted Not applicable Not applicable Not applicable Not applicable Not applicable 1,434”, need to be captured as “Unlisted”, “Not applicable”, “1,434”. The word length may change, it may be “applicable”.
I want to use regular expression’s matches, but cannot make it, can anyone help me maybe just the idea or just map one line of my data into excel as an example ? thx!
the txt and excel here:
test.zip (6.9 KB)