How to copy unformatted data in a file to an excel sheet

how to copy unformatted data in a file to an excel sheet.Trial_Balance___Detail_270319.xml (2.3 MB)

@mhmd_fyk Assuming the string positions for the “Account”, “Descriptions” and other column fields are fixed, then you can
1.loop through each lines in the file
2.use substring and assign each column values to datatable.
3.Write the datatable to the excel.

@pravinraj.vincent

sorry but how to Read line by line from text file then use substring .may you share simple example ?

Thanks pravinraj.vincent

@mhmd_fyk Can you share the text file.

@mhmd_fyk

Have you Heard of Macros ??
things are much simpler when it comes to macros.
you can split via Tab Delimiter give it a try.

this the text file just change the extension from .xml to .txt because the upload doesn’t accept .txt

@pravinraj.vincent

Trial_Balance___Detail_270319.xml (2.3 MB)

@pravinraj.vincent, kindly pravinraj can you help me with simple example how to parse the file.