1 Reply Latest reply: May 15, 2014 10:13 AM by Olly Bond RSS

    Removing Unwanted Records  -  (Monarch pro 9)

    demi _

      Hi,

         The field (CHARGES), I'm working with contains the following values listed below.

         I'm interested in filtering the records by removing any records which start with

         "SUR", "BAL"  and "OF" in the first column. After filtering the 8 unwanted records,

         from this example, I will be be left with 1 good record (VTL511.1).

       

      VTL511.1 (11)   |_________

      SUR=$  |   300___ BAL=$  |   300 CVA=$  |    25 BAL=$  |    25 -


      SUR=$  |   300___ BAL=$  |   300 CVA=$  |    25 BAL=$  |    25 DNA=$  |    50 BAL=$  |    50 -


      SUR=$  |    95___ BAL=$  |    95 CVA=$  |    25 BAL=$  |    25 -


      BAL=$  |    95 CVA=$  |    25___ BAL=$  |    25

      BAL=$  |    60 (433)  |_________

      SUR=$  |    95___ BAL=$  |    95 CVA=$  |    25 BAL=$  |    25 -


      OF NEW YORK

       

        Thank You Again,

         Demi