Block Report Fixed Width Parsing

[GarthWest]

Hey y'all,

I am trying to import a file that has a title line then a report in blocks of 5 rows with 5 unique fixed width patterns.

I would like to parse it all out into a table where each block is a single row. I understand how to import and add names and types with a regular fixed width txt, but the line breaks have me stumped. Any ideas?

Thanks!

West

[GarthWest]

Oh the widths are:

Header
row one: 3, 3, 3, 7, 9, 9, 7, 20, 1, 7, 8, 3, 3, 3, 1, 9, 15, 15, 8, 8, 2, 9, 1, 1, 1, 1, 1, 5
row two: 3, 3, 9, 9, 3, 3, 9, 30, 15, 1, 15, 15, 3, 1, 13, 9, 1, 1, 1, 1, 9, 1, 4, 1
row three: 3, 3, 4, 7, 11, 26, 20, 1, 8, 9, 17, 1, 1, 7, 11, 11, 4, 4, 8, 4
row four: 3, 3, 13, 11, 2, 40, 7, 7, 15, 9, 1, 10, 10, 20, 9, 8, 1, 4
row five: 3, 3, 7, 11, 20, 9, 5, 20, 20, 20, 17, 1, 2, 15, 7

Thanks again!

[Watermark · Accepted solution]

Garth, 

See attached.   If I understood correctly, you're effectively wanting to combine the 5 lines into 1 single line. 

If this works, please hit the solution accepted. 

Mark Thompson

Watermark Data

[GarthWest · Accepted solution]

Mark,

Thanks for this and sorry for the very slow reply! Yes, that is part of it. I also need to split that new row into around 95 columns. Currently, I have a workflow doing that in reverse order that has five different input tools with five different fixed widths connected to the same file. 

Each of those then go through a select records tool to pull the row relevant to the fixed width, then a record ID tool so I can join them back together in a single row:

However, I prefer the tidiness of your solution. Any insight on how I would break out the data of that single resultant column without using 95 different text to column tools?

Thank you again

[GarthWest]

Never mind. I just took the RegEx lesson👨‍🎓