2 Replies Latest reply on May 17, 2018 8:36 AM by Ryan Byford

    keep only text within parentheses in a string

    Ryan Byford

      Hello,

       

      I have a field that contains the following data:

      English (United States)

      English (Canada)

       

      I want to keep only the country name.  Therefore, I need to keep only the text that is in between the '(' and ')'.


      I tried TRIM( SPLIT( [field], "(", -1 ) ) which returns "United States)"

       

      is there a way to run TRIM SPLIT twice or is there a better way to do this?

       

      I do not want to run a FIND for every single language in the world.