Clean up html formatting stored in table column

erpexpert03

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&nbsp.

Thank you!

Esmeralda

erpexpert03

Helpful, thank you!

Gaurav Bharadwaj-Oracle

@erp_expert03

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)

Venkat Koduvayur-Oracle

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 &nbsp','&nbsp')

Regards

Venkat