Yup, thanks for that. Basically got myself stuck down a long and complicated route when in reality there was a much simpler solution staring at me all along. Appreciate the help :)
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...