TextBetween() first occurrence and last occurrence
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.
Re: TextBetween() first occurance and last occurance
Thank you! This would probably work. I will test it out. But after digging into the data of the model (built by another developer) I found that they did not need to use the closed Parenthesis as there is NO data after the final ')'. I removed it and now get all the data: TextBetween(FIELD,'(','')