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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
SK28
Creator II
Creator II

Free text Column Issue - Bold characters are showing as * (bold) values and Color values {color:#453cf} as to be removed or showed as BLANKS

,Hi,

 

I have a question, We connect our Qliksense Instance to Confluence page which is a website to extract the information

 

We have column called Description, Which is free text field.

when we are extracting the information to Qlik, I can see BOLD letter written as 

Data in Confluence  - Qlik sense is a good tool

Data in Qliksense is showing  - *Qlik sense* is a good tool  

I have used  this formula to handle

Replace(Replace(Only(Trim(PurgeChar([Description],'*'))), chr(10), ''), chr(10), '') 

Qlik sense is a good tool  --> this has been resolved

 

But now the problem is I can see if a user highlights any  text in Color it is showing as below

Data in Confluence - configuration and performance  of Integration with Qliksense, we will do first

Data in Qliksense - configuration and performance{color:#4c9aff} of Integration{color:#4cff} with Qliksense, We will do first{color}

Expected result - configuration and performance  of Integration with Qliksense, we will do first

 

I dont want {color:#4c9aff} & {color:#4cff} & {color} in my description.

Labels (2)
1 Reply
SK28
Creator II
Creator II
Author

Replace(Replace(Replace(Only(Trim(PurgeChar([Description],'*'))), chr(10), ''), chr(10), '') ,'{color:#4c9aff}', '')

 

adding one more replace is working but I want to Search '{color*}' String and replace all of them with  '' (Blanks)

please help me on this