Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 208 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 76 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Remove HTML tags in columns without rendering OTBI

Description
I would like to have the ability to report on "comment"-columns that contain HTML without being forced to render the HTML in column properties. So I would just like to have the plain text without any html tags ... or plain text without the html formatting ...
Before I have been able to use EVALUATE REGEXP REPLACE for this purpose ... this is not an option anymore unless I build the report in BI Publisher.
Use Case and Business Need
-
Original Idea Number: 97854788c3
Comments
-
Hi,
Try the solution from this Support doc:
How do I prevent the text entered into Workforce Management Goals 'Success Criteria' Field from displaying with HTML tags, in my analysis ? (Doc ID 2027085.1)
Regards,
Tito1 -
Hi Tito,
I couldn't find the support doc you're referring. Could you please paste a url to the doc?
Thanks,
Maciej
0 -
Hi,
We have been experiencing the same issue that Naim has raised.
It's not possible to export this data into Excel at all and it is an urgent requirement from senior staff across our organisation.
Really hope that a fix for this Bug can be found soon.
Andrew
0 -
I posted a sample report that removes HTML tags, not for the same subject area, but the concept will be the same. See the code snippet on the post, it is a bit of a chore to figure out all the tags and list them all. In the code snippet I've removed the <br>, <p> and </p>. It's located here.
https://cloudcustomerconnect.oracle.com/posts/818b572b1d0 -
Hi Team,
I am facing the same issue currently; can anyone please help me with the solution.
0 -
Review the Code Snippet in the link I provided.
0 -
Hi Gail,
when i am trying to access the link, it shows page Not Found.
0 -
REPLACE(REPLACE(REPLACE("Compensation Notes"."Compensation Note" ,'<br/>',''),'<p>',''),'</p>','')
You have 3 choices. You can use a formula like above. You can use column properties. If you use plain text, then html tags will appear. If you use html, then tags will go away.
0