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

    remove unwanted values, charters ...etc

    demi _

      Hi,

         My field is called "charges" and it contains the following 3 values;

      VTL511.1 (PG) (5)

      BAL=$  |    60 (433)

      VTL511.1 (11)

       

         How do I remove (5), (433) and (11)? Can this be done with one calculation field?

       

      Demi