Oli, thanks for your suggestions. Please post any further suggestions on this topic: [url="http://mails.datawatch.com/cgi-bin/ultimatebb.cgi?ubb=get_topic;f=1;t=000992"]http://mails.datawatch.com/cgi-bin/ultimatebb.cgi?ubb=get_topic;f=1;t=000992[/url] -- especially for new Monarch features.
Regarding using the pipe character "|" as a field separator, Monarch Pro can in fact already do this. Open Monarch Pro, select File -> Open Database, select your file as a delimited text file (*.csv, etc.) and you can specify your delimiter character as "|" after clicking on the "Other" radio button.
See also this similar Q&A:
which lead to this Monarch Tip in the Feb. 2003 issue of The Monarch Report (see Page 6):