Thank you for taking a look.
The problem is I'm having trouble pulling out each individual code because the alignment of the codes overlap from line to line throughout the file. I want all the codes to come out in just one column.
all the way through
What I can get using several formula fields is:
19 Other 0801 0802 0803
19 Other 1199 9651 9731
Etc. : Multiple rows and columns of numbers not just three columns with
Category : Cat Description : Code
This is simple in a single Monarch model assuming you don't have more than 100 codes more record. Trap the line with the code as a multi-line detail template and include in the sample the first line of the 0123, 0124 codes.
Select the fields you need from the first line as normal. Select the entire line of 0123 etc as one big field called BLOB. Make this a Memo field, and in Advanced Options set it to "end on blank field values" of 1. Now define the MultiColumnRegion as active, with the columns starting in position 150 and each one having a width of 1.
Now in the table, define a calculated field called Code as lsplit(intrim(Blob);100;" ";Column()) - you chop the block of text into pieces based on the Column function. For your final export you might find that a summary with Category, Description and Code as a the three key fields will give you the formatting and display control you want.
The technique is presented here - it shouldn't take more than five minutes work, but if you need help, our standard charge for model building is USD 750 and we'd be happy to assist. Greenbar Analytics - Invisible Data - now visible