3 Replies Latest reply: Nov 10, 2015 5:40 PM by DataExploiter _ RSS

    Help Capturing Dates from Data

    Stacey Payne

      Hello All, I am a new user of Monarch Pro and am having difficulties figuring out how to grab data from a file.

       

      Basically I have a list of loan numbers and then a list of transactions and dates below that, I need to grab the loan number and the earliest date listed under it. I have been able to grab all the fields from the data set I am working with but am unable to grab the oldest date for the particular loan number listed.

       

      Below is an example of the data from the file I am working with:

       

      P3461-105                            .                                               11/02/15

                                                               SUSPENSE REPORT                                                    PAGE   2

      ------------------------------------------------------------------------------------------------------------------------------------

         LOAN NO     MTGR NAME  DUE DATE       SUSPENSE BAL     TOTAL PMT   ERR CD BANK  CAT  TYPE  DIST  OFF MAN ST PROC                

      ------------------------------------------------------------------------------------------------------------------------------------

         (DETAIL)    SUSP DATE  DUE DATE TRAN  SUSPENSE AMT     TOTAL RECD  ERR CD BATCH  SEQ NO  PMT EFF DATE                           

      ------------------------------------------------------------------------------------------------------------------------------------

       

      8888888888   J  Doe      01-01-15             422.40       2,029.05   0801   210  063   13    1    01   3  MD  T                  

              1041.22 P&I  987.83 ESM   .00 LF   .00 A&H .00 BSC   .00 MIS   .00 HUD-P     .00 HUD-B  611.75 L/C   41.65 1LC     .00 INT-D

                                                                                                                             4653.93-DEF 

                     10-22-15   11-01-14 073         422.40       4,283.50   0801   BB6   184131   10-22-15                              

       

      8888888888   J  Doe      08-01-15             252.04         631.96   1029   012  244   13    1    06   9  SC  9                  

               533.66 P&I   98.30 ESM   .00 LF   .00 A&H .00 BSC   .00 MIS   .00 HUD-P     .00 HUD-B     .00 L/C   21.35 1LC     .00 INT-D

                                                                                                                                1.04-DEF 

                     10-15-15   07-01-15 073         631.96-           .00   0029   929   999999   10-15-15                              

                     10-15-15   07-01-15 072         442.00         442.00   1029   801   031274   10-15-15                              

                     08-20-15   07-01-15 072         442.00         442.00   1029   801   067822   08-20-15                              

       

      8888888888   J  Doe      11-03-15                .46         746.54   1923   014  002   38    1    40   3  VA  T                  

               746.54 P&I     .00 ESM   .00 LF   .00 A&H .00 BSC   .00 MIS   .00 HUD-P     .00 HUD-B     .00 L/C     .00 1LC     .00 INT-D

                                                                                                                              464.00-DEF 

                     10-14-15   10-03-15 073         746.54-           .00          BB7   274758   10-13-15                              

                     10-13-15   10-03-15 070         746.54         746.54          811   179887   10-13-15                              

                     09-15-15   09-03-15 073         744.54-           .00          BB3   019785   09-11-15                              

                     09-11-15   09-03-15 073         745.00         745.00   1923   542   164129   09-11-15                              

       

      8888888888   J  Doe      11-01-15             120.40         702.80   102T   100  565   12    1    05   3  AL  T                  

               527.21 P&I  175.59 ESM   .00 LF   .00 A&H .00 BSC   .00 MIS   .00 HUD-P     .00 HUD-B     .00 L/C   21.09 1LC     .00 INT-D

                     10-20-15   10-01-15 073         702.80-           .00   0801   BB1   015273   10-19-15                              

                     10-19-15   10-01-15 072         720.00         720.00   102T   801   150917   10-17-15                              

                     09-11-15   09-01-15 073         702.80-           .00   0801   BB1   132430   09-10-15                              

                     09-10-15   09-01-15 072         720.00         720.00   102T   801   074079   09-10-15                              

                     08-11-15   08-01-15 073         702.80-           .00          BB1   144128   08-10-15                              

                     08-10-15   08-01-15 073          17.20          17.20   102T   802   111159   08-10-15                              

                     08-10-15   08-01-15 072         702.80         702.80   102T   801   112614   08-08-15                              

                     07-14-15   07-01-15 073         702.80-           .00   0801   BB1   016008   07-13-15                              

                     07-13-15   07-01-15 072         720.00         720.00   102T   801   168210   07-11-15                              

                     05-19-15   05-01-15 073          34.40       1,440.00   0801   BB9   099243   05-19-15                              

                     04-03-15   04-01-15 073         702.80-           .00          BB1   109369   04-02-15                              

                     04-02-15   04-01-15 072         720.00         720.00   102T   801   046397   04-02-15                             

       

      Does anyone have any suggestions how I can trap this using the template feature? Or other features within Monarch?