FORMATTING DATA FROM MAINFRAMES

Good Day. At times I get files from Mainframes that I process in Alteryx.

The raw output is in "00-ACTUAL-DATA.txt"

The data needs to be processed as in 01-EXPECTED-DATA.txt before we get the final output as in "02-EXPECTED-FINAL DATA.txt"

Once data in in "02-EXPECTED-FINAL DATA.txt" format, I can process it into excel/some DB

Accepted answers

@chinu267 , if i understood well, here is the solution. This one is not so trivial.

@chinu267
I am also not quite sure what I am doing is corect or not.
Just read the text one row each, the apped the data row having 'OUT '.

can I ask, why would you do anything in Excel? What is the final format you want in Excel?

The final output needed is 02-EXPECTED-FINAL DATA. Only thing here we need is split the fixed width data into different columns

Interesting problem.

@chinu267 , if i understood well, here is the solution. This one is not so trivial.

@chinu267
I am also not quite sure what I am doing is corect or not.
Just read the text one row each, the apped the data row having 'OUT '.