Oracle Communities

Oracle Analytics and AI

Child Item

How to remove HTML tags in Column Values?

Hi everyone,

Kindly seeking your assistance with an issue in the column values that shows HTML tags. The data is being saved in the backend with HTML tags that's why the report is fetching it like that. Is there any column properties or condition that I can do to the column values to remove the tags?

I tried to use the REPLACE but the tags are too many and I think it is not the best solution.

Regards,

Ivony

Find more posts tagged with

Reporting

column

OTBI (Oracle Transactional Business Intelligence)

values

Accepted answers

Hassan El Bouihi-Oracle

Hello Ivony,

If this is an OTBI analysis, you could set the column to HTML and it will display the content without the HTML tags. Here are the steps to do that.

Edit the column in question by clicking on the gear icon and selecting Column Properties
Click on the Data Format Tab
Check the override default Data Format
set the Treat Text As to HTML
Click OK
Save the analysis and test.

Thank you
Hassan

All comments

Hassan El Bouihi-Oracle

Hello Ivony,

If this is an OTBI analysis, you could set the column to HTML and it will display the content without the HTML tags. Here are the steps to do that.

Edit the column in question by clicking on the gear icon and selecting Column Properties
Click on the Data Format Tab
Check the override default Data Format
set the Treat Text As to HTML
Click OK
Save the analysis and test.

Thank you
Hassan

MandeepGupta

https://community.oracle.com/products/oracleanalytics/discussion/26579/how-to-remove-html-tags-in-column-values

Hi,

Unfortunately, there is no better way of doing this other than using REPLACE. This is recommended by Oracle Support as well:

Oracle Fusion Recruiting Cloud: OTBI: How to Remove HTML or Other Code from Analysis Results (Doc ID 2956341.1)

Oracle Taleo Enterprise Edition: How to Remove HTML Code from Column Results in Reporting (Doc ID 2052395.1)

Thanks.

Ivony Ann Paula Salango

Hello @Hassan El Bouihi-Oracle, this resolved my issue. Thank you!

@MandeepGupta , the usage of column properties worked for now, if ever we encountered more issues like this we will try to use the REPLACE. Thank you for looking into this.

Appreciate all your time.

Regards,

Ivony