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

    keep only text within parentheses in a string

    Ryan Byford



      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.