General OBIEE

Get Involved. Join the Conversation.

Topic

    Geoff Fredericksen
    Removing HTML tags from a datbase field
    Topic posted December 13, 2015 by Geoff FredericksenRed Ribbon: 250+ Points, tagged Report Layouts 
    140 Views, 1 Comment
    Title:
    Removing HTML tags from a datbase field
    Summary:
    Remove HTML tags saved in database field
    Content:

    Hi,

    I have an sql data model retruning HCM performance review data. One of the fields returned is a comments field varchar(4000). The data saved to this field is entered via the user interface and an html text editor.

    The comments data is saved with the html tags. When I do a Publisher report the tags are displayed in the output column, no matter what output type used.

    How to I remove the tags so that only plain text is output?

    Thanks

    Comment