2 Replies Latest reply on Feb 4, 2013 9:13 PM by karstend

    How to "Split" text

    karstend

      Still working in FM8 - maybe it is time to move up.

       

      Any solution to splitting a text into 3 field or values when the text is divided with "_"?

      ie:

      backer_PB_Pl1

      or:

      CL_PB_CL.

       

      KarstenD

        • 1. Re: How to "Split" text
          LyndsayHowarth

          Using the substitute() function you can replace the underscore with eg a return character.

          They then become values which can be referred to in other calculations by their value number.

           

          You can also use a mix of left(), right(), leftwords(), rightwords(), position(), middle() etc to extract bits...

          eg. Find the position of the first underscore and get left (field, position - 1)

           

          HTH

           

          - Lyndsay

          • 2. Re: How to "Split" text
            karstend

            I was looking at the "return character" but did not make the connection.

            I'll try it tomorrow - out of time now.

             

            Thanks

             

            KarstenD