2 Replies Latest reply: May 15, 2014 10:03 AM by joe.lovati _ RSS

    Version 7 challange

    joe.lovati _

      So, my challange is I'm trying to trap the line with # symbol, and then the FATAL and INFO lines below it.  But I want all the FATAL and info lines in one cell.  I've tried the advanced field options of when to end a field and none of them seem to be working. 

                                                                                      MM/DD/YY                                                                               

      PAGE    4                                                                               

      -


           

      LOAN              ARM                    AMORTIZED         ORIGINAL          DEFERRED     MAXIMUM    LOAN COMPUTED   # OF   NXT CALC   

      NUMBER            PLAN INV DUE-DATE       PRIN BAL/TERM    PRIN BAL/TERM      INT BAL     NEG AM BAL TYPE CALC DATE  CALCS  DATE       

      -


           

      1. 0000000001     W12A 616 02/01/09      85,187.80  240      76,500  360          .00            .00  13  01/17/09     1    01/20/09   

           FATAL  401.0-PI ARM-UPDATE-STOP = H; ARMZ2 OVERRIDE =  .                                                                               

      INFO   415.0-UD ONE OR MORE IR CHANGE CAPS APPLIED.                                                                               

      INFO   013.2-IR 01.00000 % PER CHANGE MAX DECREASE CAP APPLIED. (BASE: 10.35000 %)                                                

           INFO   016.2-IR 10.35000 % LIFE-TIME  MAX DECREASE CAP APPLIED. (STATED AMOUNT)                                                   

           INFO   042.2-IR UNCAPPED NEW IR < CURRENT IR BY MORE THAN 001%. (0027.50%) (CLT OPT EXCESSIVE CHANGE MESSAGE)                     

       

      1. 0000000002     W12A 626 01/01/08         176.67- 252      90,000  360          .00            .00  13  01/17/09     1    01/20/09   

         IR CHG:   NEW  IR:   .00000    IR CALC METHOD : 1          MAX IR INC/CHG:  1.00000   MAX LIFE IR: 15.45000 A OLLW:      01/22/09   

        02/01/09   PREV IR:  9.45000    NEW INDEX      :   .00000   MAX IR DEC/CHG:  1.00000   MIN LIFE IR:  9.45000 S RND : N .12500        

      (03/01/09)                                                   MIN IR INC/CHG:            IX MTD, RND: I   .00000 INDX/LEAD M&D/AVG     

        PER:   6                        MARGIN         :  5.45000   MIN IR DEC/CHG:            IR LEAD M&D:   0 / 15   WSJ1   0 / 15  N  0   

                                        UNCAPPED IR    :  0.00000   PMTS TO BR:  1  (09/01/08) CAP BASE RT:  9.45000                         

         PI CHG:   NEW  PI:        .00  PI CALC METHOD : F              MAX PI INC:            MAX PI AMT:             OLLW:AW001 01/22/09   

        03/01/09   PREV PI:     757.17  FULL AM PI (IR):        .00     MAX PI DEC:            MIN PI AMT:             PI DISC:              

        PER:   6   ORIG PI:     753.49  FULL AM PI/15YR:        .00     MIN PI INC:            PB CALC MTD: 1                                

                   UNCP PI:        .00  INT. ONLY PI   :        .00     MIN PI DEC:            PI LEAD M&D:   1 / 15                         

         PR CHG:   NEW  PR:   .00000    PR CALC METHOD : C          MAX PR INC/CHG:            MAX LIFE PR: 15.45000 A UNCAP PR:   .00000    

        02/01/09   PREV PR:  9.45000    NEW INDEX      :   .00000   MAX PR DEC/CHG:            MIN LIFE PR:  9.45000 S RND :   .00000        

      (03/01/09)                                                   MIN PR INC/CHG:            IX MTD, RND:     .00000 INDX/LEAD M&D/AVG     

                                                                    MIN PR DEC/CHG:            PR LEAD M&D:   0 /  0                         

           FATAL  073.0-PI CANNOT COMPUTE FULLY AMORTIZING PI, BECAUSE PREVAILING INTEREST RATE IS ZERO.                                     

           FATAL  090.0-PL PRINCIPAL BALANCE AMORTIZED TO ZERO BEFORE THE CHANGE DATE 03-01-09.                                              

       

      1. 0000000003     FX10 435 10/01/08     597,911.33  324     567,999  360          .00            .00  13  01/17/09     1    01/20/09   

         IR CHG:   NEW  IR:  7.99000    IR CALC METHOD : 1          MAX IR INC/CHG:  1.00000   MAX LIFE IR: 14.99000 A OLLW:      01/22/09   

        02/01/09   PREV IR:  5.00000    NEW INDEX      :  1.75000   MAX IR DEC/CHG:  1.00000   MIN LIFE IR:  7.99000 S RND : N .12500        

      (03/01/09)                                                   MIN IR INC/CHG:            IX MTD, RND: I   .00000 INDX/LEAD M&D/AVG     

        PER:   6   CURR PI:    2491.30  MARGIN         :  5.99000   MIN IR DEC/CHG:            IR LEAD M&D:   0 / 15   WSJ1   0 / 15  N  0   

                   I.ON PI:    3981.09  UNCAPPED IR    :  7.75000   PMTS TO BR:  1  (09/01/08) CAP BASE RT:  5.00000                         

                   F.AM PI:    4505.88                                                                               

      INFO   411.0-UD ARM LOAN DATA UPDATED SINCE LAST IR/PI CHANGE.                                                                    

           INFO   415.0-UD ONE OR MORE IR CHANGE CAPS APPLIED.                                                                               

      FATAL  436.0-IR LOAN WILL NEGATIVELY AMORTIZE; NO MAX PRIN BAL ENTERED, SO NEG AM PI NOT CALCULATED                               

           INFO   013.0-IR 01.00000 % PER CHANGE MAX INCREASE CAP APPLIED. (BASE: 05.00000 %)                                                

           INFO   016.2-IR 07.99000 % LIFE-TIME  MAX DECREASE CAP APPLIED. (STATED AMOUNT)                                                   

           INFO   041.0-IR UNCAPPED NEW IR > CURRENT IR BY MORE THAN 050%. (0055.00%)  (MSP EXCESSIVE CHANGE MESSAGE)                        

           INFO   042.0-IR UNCAPPED NEW IR > CURRENT IR BY MORE THAN 001%. (0055.00%) (CLT OPT EXCESSIVE CHANGE MESSAGE)                     

           INFO   041.0-IR   CAPPED NEW IR > CURRENT IR BY MORE THAN 050%. (0059.80%)  (MSP EXCESSIVE CHANGE MESSAGE)                        

           INFO   042.0-IR   CAPPED NEW IR > CURRENT IR BY MORE THAN 001%. (0059.80%) (CLT OPT EXCESSIVE CHANGE MESSAGE)                     

       

      /CODE

        • Version 7 challange
          Data Kruncher

          Hi Joe! :cool: Long time no see!

           

          Do you need the "FATAL" and "INFO" descriptors to be included, or could you do without them?

           

          Kruncher

            • Version 7 challange
              joe.lovati _

              Yeah, I was looking forward to see you all at the user conf this year, but there isn't one:(

               

              I need everything on the Fatal and Info lines.  The user wants to filter out loans that don't meet a specifc Fatal code, but wants to see all the Fatal and Info info post filter. So my intent was to capture all those lines in one cell and use calc fields to isolate the Fatal info for filtering. 

               

              Hi Joe! :cool: Long time no see!

               

              Do you need the "FATAL" and "INFO" descriptors to be included, or could you do without them?

               

              Kruncher[/QUOTE]