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