I'm working as a consultant for a mortgage company. I've written an application that automates the process of grabbing files from an ftp folder and then loading them into an Access database for various users to work with.
I've had good luck with Monarch so far, but I'm having difficulty with the following records. I've read everything I can find on multiple line wrapping, but I'm just not getting it. Hopefully someone here can help.
I've put sample data below. The NNNNNNNN strings represent the loan number.
The problem is with the last column, which wraps to the next line. In sample 1, you can see where there is a value in the top line and then more detail in the next line:
NNNNNNN NNNNNNN 07-10-06 50 118.37 123.59 621.45 621.45 745.04 99,308.91 99.30-REP
123.59 DI REPAID .00 ASSET INV REPAID
745.04 .0750000 .0000000 05-01-06 /font[/quote]In sample two, there is a second wrapped line, but there is nothing in the first line.
NNNNNNN NNNNNNN 07-10-06 37 193.41 114.61 755.67 755.67 870.28 120,792.60
114.61 DI REPAID .00 ASSET INV REPAID
870.28 .0750000 .0000000 06-01-05 /font[/quote]In sample 3, there is no data in the field at all.
870.28 .0750000 .0000000 06-01-05
/font[/quote]I've tried creating a multiple line field, but it doesn't appear to wrap on the second line, just starts at the same point as the first line, which won't work, as you can see from the samples above.