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

Announcements
Save $650 on Qlik Connect, Dec 1 - 7, our lowest price of the year. Register with code CYBERWEEK: Register
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