Oracle Transactional Business Intelligence
Removing HTML tags from a datbase field
Remove HTML tags saved in database field
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?