FORMATTING DATA FROM MAINFRAMES

[chinu267]

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

[mceleavey]

Hi @chinu267 ,

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

M.

[chinu267]

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

[Inactive User]

Interesting problem.

[Felipe_Ribeir0 · Accepted solution]

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

[Qiu · Accepted solution]

@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 '.