Categories
- All Categories
- 4 Oracle Analytics Sharing Center
- 9 Oracle Analytics Lounge
- 182 Oracle Analytics News
- 39 Oracle Analytics Videos
- 15.3K Oracle Analytics Forums
- 5.9K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 62 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Clean up html formatting stored in table column

We are using notes to store data in an application table (Oracle Cloud PPM, Project setup); users are copying and pasting data from an html page and inadvertently pasting in html formatting into the field.
Is there a way to programatically clean this data.
for example
text
I want to only output text onto an Excel OTBI report. right now it outputs text .
Thank you!
Esmeralda
Best Answer
-
Helpful, thank you!
0
Answers
-
Hi Esmeralda, have you tried overriding the data format by changing it to HTML in Column properties for the column which is having those HTML tags.
Have a look at this doc : Success Criteria In Goals Is Stored With HTML Tags In The HRG_GOALS Which Is Displayed In OTBI (Doc ID 1934283.1)
0 -
Hi
You could use OAC evaluate function to execute a db function for regexp_replace to achieve this.
Something like
evaluate('regexp_replace (%1, %2)','Hello  ',' ')
Regards
Venkat
0