topic Remove accolades {} using text functions in Qlik Automate

Remove accolades {} using text functions

Fred — Wed, 03 Jul 2024 12:16:57 GMT

Hi,

I want to use the text functions to remove accolades from a string.
Because of the application automation syntax that uses accolades, this always fails and is not recognized.
How do I avoid this?

Example:

This becomes:

This formula is not recognized and gives this as output:

Same is happening if I try to use regex parse.

Thanks,
Fred

Re: Remove accolades {} using text functions

Fred — Mon, 15 Jul 2024 13:13:01 GMT

I've logged a support ticket and this is a product limitation.

Qlik Support answer:
"R&D mentioned that this is a current product limitation our formula parser can't process {} within strings.
The general workaround for this would be to use the custom code block.
We will also most likely add this limitation to our user guide for QAA."

The workaround with the custom code block works, but is of course an extra step.
I've created this idea to add {} as characters that work in text functions.
Idea: https://ideation.qlik.com/app/#/case/403133