3 Replies Latest reply on Jan 30, 2018 8:04 AM by Sasha Hanna

    EXTRACTION FUNCTION

    wiem bekir

      Hello Guys,

       

      I have a filed that contains telephone description PORTABLE HUAWEI GPLAY MINI, i would like to extract the expression after 'PORTABLE HUAWEI'

       

      The output would be GPLAY MINI

       

      Any function that returns the needed result ?

       

      THANKS

        • 1. Re: EXTRACTION FUNCTION
          Sasha Hanna

          Hi Wiem,

          You could try to use to return everything after the second space:

           

          MID([Field],FINDNTH([Field]," ",2))

           

          If you are only looking for the expression then replace space with the text:

           

          MID([Field],FINDNTH([Field],"PORTABLE...",1))

           

          Let me know if this helps.

           

          Cheers,

          Sasha

          • 2. Re: EXTRACTION FUNCTION
            wiem bekir

            hello sasha,

            i did that but it didn't wor:

             

            MID([Product Description],FIND([Product Description],"PORTABLE SAMSUNG",2))

             

            result : PORTABLE SAMSUNG GALAXY J1 ACE

             

             

            Thanks

            • 3. Re: EXTRACTION FUNCTION
              Sasha Hanna

              Hi Wiem,

              Did you try using the function "FINDNTH"? This will return the position where to split the text. The "2" in your formula returns the second occurrence of the substring as opposed to the first, so it should read "1"

               

              MID([Product Description],FINDNTH([Product Description],"PORTABLE SAMSUNG",1))

               

              Cheers,

              Sasha