Hi, I’m now work with txt file that I have to xlsx file. The txt file it self cannot converted using generate data table because its not have a delimiter to define a column, I have to substring each row from spesific index to get a column data. Is there a more efficient way other than split new line than loop and substring each row? I attach an example of the file also, I have to get index 4-8 for Column 1, and index 45-54 for Column 2
Example.txt (2.0 KB)
Thank you and have a nice day!