Block Report Fixed Width Parsing

Question

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

Markup RPT.txt

Watermark · Accepted Answer

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 Answer

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