Both the Trim and Substitute functions do not work well with parenthesis

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 \


1 Like