Categories
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
