3 Replies Latest reply: Feb 3, 2017 12:04 PM by Deborah Pyykkonen RSS

    TextBetween()  first occurrence and last occurrence

    Deborah Pyykkonen

      How do I set the text between to find the first occurrence of a value and the last occurrence of another value?

       

      TextBetween(FIELD,'(',')')

       

      is what I am needing but I want it to get all the text between the first occurrence of the open parenthesis ( and the last occurrence of the closed parenthesis because the user could input  open and closed parenthesis in the text input.

       

       

      TextBetween(FIELD,'(',')',SUBSTRINGCOUNT)  I tried using a substring count here but it relates to the first criteria for the open parenthesis not the last close parenthesis.

       

      What is the best way to do this?