Under Options, Input Options, you can change to the Alternate trap characters (with Monarch versions after v8, IIRC).
But I don't believe that a floating trap is going to work out too well for you with a sample like that.
Instead, I'd recommend that you capture the entire line as a single field, and then slice and dice it into the five fields that you really need using calculated fields that employ the LSplit function to break the larger string into sections using the | character as a delimiter.
So for the first record, LSplit(MyField,5,"|",2) would return LAGUIRRE and LSplit (MyField,5,"|",3) would return LUCY, and so on.
It's a bit more work up front than a floating trap would be but you'll get much better results in the long run.
You might be interested in a [URL="http://********************/calcfield/handling-floating-or-missing-values-with-monarch"]similar example[/URL].
Hello Lori, hello Kruncher,
Just to add my 2p worth...
Grabbing one big field and using Lsplit is great as long as your data has regular separating characters. You will need to work around the 254 character field limit, but you could concatenate several of these into a memo field before applying the Lsplit approach.
LSplit does allow you to cope in advance with individual field widths that may fluctuate a lot from your sample - trying to do this in the template interface can be fiddly and give you a "sample line must exactly match selection line" error.
Floating trap is much better when the separating characters might be wildcards. Building an Lsplit to break a string on the occurence of any digit from 0...9 or any character from A...Z would be frustrating.
With the sample in this thread, I would consider using Monarch Pro to open the data as a database instead of as a report, as there doesn't appear to be any irregularity in the field structure?
With the sample in this thread, I would consider using Monarch Pro to open the data as a database instead of as a report, as there doesn't appear to be any irregularity in the field structure?[/quote]
Well, there you go again... taking all the fun (and work) out of it, making it even easier to excel with Monarch.