I have this txt file and want to write it in excel .
I m unable to split the text file into rows and columns.
i m totally stuck in this.sample.zip (515 Bytes)
Create a table with desired column format
Read the text file, replace all double Spaces with single spaces until you find double spaces.
First split the text with Newline
For each found line split with space and the array which you get will be input for Add Data Row to the table Property ArrayRow.
Thanks,
Madhura