Oracle Transactional Business Intelligence

Products Banner

Removing HTML tags from a datbase field

63
Views
3
Comments

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

Tagged:

Comments