This content has been marked as final. Show 3 replies
How do I set the text between to find the first occurrence of a value and the last occurrence of another value?
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?