I have a similar issue.
I wish to find a particular piece of text at the end of a text field, then replace only those characters (ie only appearing at the end of the field) with "".
For example, I wish to remove " UK" from the end of a text field.
"Academy of Ukelele Players UK"
would...