Oracle Transactional Business Intelligence

Home› Oracle Analytics› Forums› More Solutions› Oracle Transactional Business Intelligence

Categories

Clean up html formatting stored in table column

Accepted answer
96
Views
3
Comments
erp_expert03
erp_expert03 ✭
in Oracle Transactional Business Intelligence

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

Tagged:

Best Answer

Answers

  • Gaurav Bharadwaj-Oracle
    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
    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