Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 16 Oracle Analytics Lounge
- 215 Oracle Analytics News
- 43 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 79 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
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
Best Answer
-
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
Hassan0
Answers
-
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.
0 -
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
1
