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 [image] [image] [image] The original attempt as shown in the above screenshots, e…

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

OlgaStroilova March 22, 2025, 1:30pm 2

Thanks for posting. Let me connect with the team to understand whether this is a regression or a known limitation.

Topic		Replies	Views
SUBSTITUTE bug with \| (vertical bar) character Support, Troubleshooting, & Help bug , expression-editor	2	48	November 19, 2025
SUBSTITUTE() Error with '[' as the string to replace Support, Troubleshooting, & Help	4	55	November 19, 2025
Trim spaces form text within a variable Support, Troubleshooting, & Help	3	369	April 21, 2022
Extended characters having odd behavior on SUBSTITUTE()? Support, Troubleshooting, & Help	1	120	May 15, 2024
What is the logic behind the automated rewrite in the expression editor? Support, Troubleshooting, & Help	2	367	March 15, 2023