Hi Bill, and welcome to the forum.
You can handle this task with Monarch, but it'll require two models. The first will convert the single line data into multi-row data and export a new text file. The second model will extract data from the newly exported file which has a Monarch-friendly layout.
To create the first model, you want a create a single 1465 character field, so it'll be a Memo field. Name it "A".
Next, build a calculated Memo field to get the multiple row format you need. Since you know the fixed structure it's easy to model.
Substr(A,1286,180)+Chr(13)[/code]The extra blank line at the end makes building the second model easier.
Hide the A field, and in your export options menu, uncheck the option box to include field names as the first row of output.
Now export the table as a fixed-length text file, and build a straightforward model for that file.
Still a 2 step process but ...
Have you checked out the Monarch Utility?
One part of that offers the opportunity to split lines into sections. It mentions lines longer than 4000 characters but as far as I know there is no reaspon not to use it for shorter lines as well.
The end result should be something quite close to Kruncher's solution so it may be a 'swings and roundabouts' situation.
I will give it a shot.
Question - Grant - where would I find the Monarch utility you referenced ??[/quote]
It would normally install with an entry in the menu items listed along with the Monarch application and a couple of user and training guides.
If not there - are you a network or stand alone installation? Do you have the original download files or disk?
I have a stand alone install & I have the install disks - so I will look for it.
One other question - when I try to define a detail line and put a memo field in for the entire 1465 characters, Monarch comes back with "Max length Exceed'. It seems to want to limit me to 254 characters - even though I read somewhere that a memo field could be as large as 60,000 chararacters or larger! . Any trick to defining a long memo field within the template definition screen??
To be honest, I'd not tried to actually build the field that would be 1465 characters wide.
It does seem that you're limited to 254 characters though. I don't think that in all this time I'd ever run into that...
No matter though, it's a quick workaround to build a few 254 character fields, side by side, then use a calculated memo field to connect them all up. Say fields A, B, C, D, E and F are 254 (A to E) and 195 characters.
The calculated FullText would just be:
Then split up FullText.