Hello!
I am in the process of developing a benchmarking tab to compare product performance. In using the button dropdown, I have indicated my wrapping characters to be single quotes, e.g. 'Apple' -- otherwise throws an error.
I am facing issues when I try to select a product value that already contains a single quote in the name, e.g. Apple's. I have tried to use the backlash escape character but that did not work.
Any help would be greatly appreciated!
Hello Holly.
Try adding this formula:
REPLACE(table.column,'\\'','\\\\\\'')
This will replace ' by \\'
Remove the Escaping character from the Button Dropdown.
(this will not work for string variables, only for database fields with ' )
Thank you.
Daniel.
Hello Holly.
Try adding this formula:
REPLACE(table.column,'\\'','\\\\\\'')
This will replace ' by \\'
Remove the Escaping character from the Button Dropdown.
(this will not work for string variables, only for database fields with ' )
Thank you.
Daniel.
Hi Holly.
The formula replaces the single quote with the \\' (escape character and single quote); this way, you can use strings like 'Apple's' inside components without problems.
Another option is to replace ' with ` :
REPLACE(table.column,'\\'','`')
Check the images below.
(The best approach would always be to cleaning up at source)
you can find more info here: https://help.celonis.cloud/help/display/CIBC/STRING
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
