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.
sorry but how to Read line by line from text file then use substring .may you share simple example ?
@mhmd_fyk Can you share the text file.
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
Trial_Balance___Detail_270319.xml (2.3 MB)
@pravinraj.vincent, kindly pravinraj can you help me with simple example how to parse the file.