Let's Reconnect, thank you for making 2022 our best year yet.

Look Back
Removing HTML tags from a datbase field — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Removing HTML tags from a datbase field

50
Views
1
Comments
edited Dec 14, 2015 3:12AM in General Transactional Reporting (OTBI) 1 comment

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:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!