Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
Fred
Partner - Creator
Partner - Creator

Remove accolades {} using text functions

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:

FredV_0-1720008768874.png

This becomes:

FredV_1-1720008791367.png

This formula is not recognized and gives this as output:

FredV_2-1720008821382.png


Same is happening if I try to use regex parse.


Thanks,
Fred

Labels (1)
1 Reply
Fred
Partner - Creator
Partner - Creator
Author

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