Categories
- All Categories
- 4 Oracle Analytics Videos
- 13.7K Oracle Analytics Forums
- 5.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 57 Oracle Analytics News
- 31 Oracle Analytics Trainings
- 53 Oracle Analytics Data Visualizations
- 2 Oracle Analytics Career
- 2 Oracle Analytics Industry
- Find Partners
- For Partners
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
Comments
-
Hi,
I guess you have found the solution since 2015, but just in case: change the text format in the column properties to HTML (see attached screenshot).
The tags won't appear anymore in the report.
Yves
0 -
@Yves Blanc here I think we are talking about a BI Publisher data model. we have the same requirement to remove all the HTML elements from a rich text comment of a performance document. so it would be useful to have a standard function to do it
0 -
@Alberto Boccato This might be what you are looking for, have a look : Fusion Applications : How To Remove HTML Tags In BI Publisher Report (Doc ID 1953480.1)
0