Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
,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.
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