Reporting and Analytics for ERP

Get Involved. Join the Conversation.

Topic

    Nishanth B Jain
    How to remove html tags from report outputAnswered
    Topic posted February 24, 2019 by Nishanth B JainBronze Crown: 15,000+ Points, last edited March 26, 2019, tagged Fusion Supply Chain Management reporting, OBI Answers, OBIEE Answers, OTBI, Reports, Sample Reports, Tip 
    92 Views, 3 Comments
    Title:
    How to remove html tags from report output
    Content:

    Hi team,

    We built some Analysis based on Sourcing related subject area's

    Where we see some html texts in the resulting columns like below.

    How remove these sufix and prefix html tags from the text.

    Thanks,

    Nishanth

    Image:

    Best Comment

    Murali Gangidi

    Hi,

    I am able to remove the HTML Text based on the metalink notes below.

    How To Remove All HTML Tags From BIP Report (Doc ID 2404894.1)

    Use regexp_replace(<field_name>,'<[^>]*>')

     

    Comment

     

    • Pras Ramakrishnan

      If your tags are always going to show up with fixed length as a prefix and suffix, you can use substring function in the expression editor in criteria to remove them. It may be challenging to remove inline tags like &nbsp; though. It may be better to understand why the tags are getting into the source column 'Requirement Text' though and see if there is anything you can do to change that. 

      Thanks,

      pras

    • Aaron Leggett

      In-line HTML might be difficult to get rid of, but you could always try to edit the Column Properties > Data Format > Override Default Data Format > Treat Text as HTML. Should get rid of the opening + closing tags.

    • Murali Gangidi

      Hi,

      I am able to remove the HTML Text based on the metalink notes below.

      How To Remove All HTML Tags From BIP Report (Doc ID 2404894.1)

      Use regexp_replace(<field_name>,'<[^>]*>')