Seeking assistance to eliminate the CSS Style tags located outside of '<>' in my SQL Server extraction. Here is a snippet from the extraction.
<HTML>
<HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<STYLE type=text/css>P { MARGIN: 0px } </STYLE>
</HEAD>
<BODY dir=ltr style="FONT-SIZE: 10pt; COLOR: #000000; FONT-FAMILY: Segoe UI">
<SPAN style="FONT-SIZE: 11pt; COLOR: black">
<FONT face="Times New Roman">
<P style="MARGIN: 0in 0in 0pt;">Actual text shows here.</P>
<P style="MARGIN: 0in 0in 0pt;"><B ><FONT size=2> </FONT></B></P>
<P style="MARGIN: 0in 0in 0pt">
</FONT>
</SPAN>
</P>
</BODY>
</HTML>
Following the removal of HTML tags with a specific function, this is the resulting output.
P { MARGIN: 0px }
Displayed actual text here.
Please take note of 'P { MARGIN: 0px }' that persists even after running the function to remove HTML tags from strings.