SUBSTITUTE bug with | (vertical bar) character

[thorsten.langner]

this is also a thing with [ and ] and others.
You can escape it with \

Please find my Post here:

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: [image] 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 \ [Screenshot 2025-03-24 091538] [image]