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
Thank you for reply, can you show me example about this step “As you know the length…use fixed length format option in generate datatable and convert the string to datatable” ? Thank you
This is how you can set the length of eqch column if there are no delimiters…just count the number of characters for each column and provide value with comma separation