1 Reply Latest reply: May 15, 2014 10:02 AM by Data Kruncher RSS

    Newbie

    dezideroo98 _

      Greetings,

       

      I just started using Monarch Pro 7.0 this week and have to learn by trial and error for an important job. I have this file that I need your assistance in trappping it correctly. The file consists of several lines of data,sometimes you have 2 lines,3 or multiple lines.  A sample of the file is listed below. I would appreciate if someone could help me. At the end of the fist line is the state abbreviation.The zip code is usually below it, depending if thereare any more lines of data. The zip code is 5 characters in length.

       

      Loan number  xxxxx   xxxx     xxxxx

                          xxxxx   xxx     xxx    xxxxxxxxx xxxxxx  State

      R       xxxxxxxxxxxxx   xxxxxxxxxxx                         55125

       

      Loan number  xxxxx   xxxx    xxxxx

                          xxxxx   xxx      xxxxxxxx        xxxxxx     State

                          xxxxx   xxxx     xxxxx                       12345

       

      Loan number  xxxxx   xxxx    xxxxx

                          xxxxx   xxx      xxxxxxxx        xxxxxx     State

                          xxxxx   xxxx     xxxxx                       12345

       

      Loan number  xxxxx   xxxx     xxxxx

                          xxxxx   xxx     xxx    xxxxxxxxx xxxxxx  State

      R       xxxxxxxxxxxxx   xxxxxxxxxxx                         55125