nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle Analytics and AI

Child Item

Remove HTML tags in columns without rendering OTBI

Naim Nayeri

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

Find more posts tagged with

Submitted

OTBI

Status: Submitted

Comments

Tmolina-Oracle

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,

Tito

Maciej Kozakiewicz

Hi Tito,

I couldn't find the support doc you're referring. Could you please paste a url to the doc?

Thanks,

Maciej

Andrew-180341

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

Gail Langendorf-Oracle

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/818b572b1d

User_7SQ56

Hi Team,

I am facing the same issue currently; can anyone please help me with the solution.

Gail Langendorf-Oracle

https://community.oracle.com/products/oracleanalytics/discussion/comment/62251#Comment_62251

Review the Code Snippet in the link I provided.

User_7SQ56

Hi Gail,

when i am trying to access the link, it shows page Not Found.

Gail Langendorf-Oracle

https://community.oracle.com/products/oracleanalytics/discussion/comment/62296#Comment_62296

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.

Notes html tags.xlsx