Categories
- All Categories
- 149 Oracle Analytics News
- 27 Oracle Analytics Videos
- 14.7K Oracle Analytics Forums
- 5.7K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 54 Oracle Analytics Trainings
- 12 Oracle Analytics Data Visualizations Challenge
- 4 Oracle Analytics Career
- 2 Oracle Analytics Industry
- 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