COGNOiSe.com - The IBM Cognos Community

IBM Cognos Analytics Platform => Cognos Analytics => Reporting => Topic started by: danii64 on 12 Nov 2018 10:57:25 AM

Title: How to Remove HTML tags to display only the report content and not the tags
Post by: danii64 on 12 Nov 2018 10:57:25 AM
Is it possible to strip HTML tags from the actual data in Report Studio? The tags are stored as part of the content styling from a webpage and is part of the actual content in db. I want to only display the content and remove all HTML tags where ever they appear.

when i run the report, the HTML tags are shown as plain text, making the content look messy and hard to read.

Any help would be appreciated.
Title: Re: How to Remove HTML tags to display only the report content and not the tags
Post by: sdf on 12 Nov 2018 11:09:32 AM
First thought will be is to use substring() or trim().
I found this old thread that might help you or give you idea.

https://www.cognoise.com/index.php?topic=26254.0 (https://www.cognoise.com/index.php?topic=26254.0)

cheers!
sdf