PeopleTools and Lifecycle Management - PSFT (MOSC)

MOSC Banner

Removing HTML/XML Tags in SQR code.

I have an existing SQR that is pulling data from a Microsoft SQL Server database. In that DB I have a text field that contains different HTML or XML tags in the string with data. I need the output of the SQR to not include these HTML or XML tags. These tags are not uniformed. Meaning they are not always the same tags. Some examples of what I am talking about is:

<div><p style="margin-bottom: 11px;"><b><span style="font-size: 10pt;"><span style="color: rgb(89, 89, 89);"><span style="line-height: 107%;"><span style="font-family: &quot;Arial&quot;,sans-serif;">


<div><span style="font-size: 9pt;"><span style="color: rgb(81, 81, 81);"><span style="line-height: 107%;"><span style="font-family: &quot;Arial&quot;,sans-serif;">

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center