How to get data from Pipe structured text file

Help
1

Hi I had another difficulty to get data from Pipe structured text file into DataTable or an excel
please refer Operation on PipeStructured file.zip (53.1 KB)
this code it contain text file and sample output excel file

2

@suraj23 Please find the file below. i have made changes and output is written in sheet2. Bit lengthy workflow, for now u can work with it.

Operation on PipeStructured file.zip (74.2 KB)

3

@suraj23
Please find the attached zip file xaml code, which writes pipeline structured data into datatable and excel.Pipeline Structure.zip (35.1 KB)