The end of one of my fields has extra text at the end of it (half the time) that i want removed. in trying both the substitute and trim functions, i found that it does not work without doing it in a roundabout way
The original attempt as shown in the above screenshots, either removes extra text that i want to keep, or doesn’t remove anything.
but if you trim just ‘15th)’ and then again trim ’ (’ it will work (The substitute will not do this and errors out)
Thanks for posting. Let me connect with the team to understand whether this is a regression or a known limitation.
For the Trim() it seems, that _is an issue, when removed in the original string. It will also remove everything before, to the next space:
This seems to apply to a space character as well!
But I can’t see issues with parenthesis here.
For Substitute() keep in mind, that some characters as ( ) [ ] \ and others need to be escaped.
The escape character is \ but it also must be escaped with an extra \
I’d been trying to escape with a single backslash this whole time! thank you for that!!
however, the issue is still that spaces are left with your final image
if i were to use right 2, then is grabs the 1 as well
So while the issue isn’t the parenthesis like i initially thought, the space(s) being left after a trim is definitely still an issue
Workaround would be:
TRIM(TRIM(@Variable.Begin Text 1, '(15th)'))
You don’t need to escape the ( & ) in TRIM() 
