2 Replies Latest reply: May 15, 2014 10:06 AM by consu _ RSS

    Calculated field assistance

    consu _

      Hi! Need some tips on how to create a calculated field, to split some of the text into a new field. The values are in different positions, but always inside brackets , but due to the PDF report, sometimes it may be many spaces before/after value , like enclosed example. In general would like hints on how to split text in variating positions in the middle of strings into new field.

       

      AUXILIARY BOILER FUEL OIL HEATER           

      AUXILIARY BOILER FUEL OIL HEATER   

      CALORIFIER

      CALORIFIER

      CARGO OIL TANK 

      CARGO OIL TANK 

      /CODE

        • Calculated field assistance
          Olly Bond

          Hello consu,

           

          If you have a field called , you could define your result as a calculated field called with the expression:

           

          intrim(Extract(;"[";"]"))

           

          Extract fetches the data between the square brackets, Intrim() removes all the unnecessary spaces...

           

          HTH,

           

          Olly

            • Calculated field assistance
              consu _

              Thanks Olly! That was just brilliant! Perfect result, and really fast service!:D

              That code will help me alot with similar formatted text.

               

              INERT GAS GENERATOR KANGRIM                   IGSKA01

              FILTER ALFA LAVAL X-280-D-40/4              FIALXD01

              PUMP SHIN SHIN NLG 5                         PPSSNL04

              COOLER DONGHWA S100-122-TKTM-37           CLRDO03

              /CODE