Remove HTML tags with regular expressions
[HTML]View PlainCopy
- Select Regexp_replace (Content, '</?[ ^>]*>|nbsp;|& ', ') content from T_test_content_config T
- ORDER BY status_date Desc;
Original CLOB content:
<p><spanstyle= "font-family: the song Body;" > "XXX Company" you have a XX has not been collected! Use </span><spanstyle= "Font-family:calibri;" >8g</span><spanstyle= "font-family: the song Body;" > Set </span><spanstyle= "Font-family:calibri;" >18</span><spanstyle= "font-family: the song Body;" > can receive </span><spanstyle= "FONT-FAMILY:CALIBRI;" >50m</span><spanstyle= "font-family: the song Body;" > Broadband, </span><span style= "Font-family:calibri;" >18</span><span style= "font-family: the song Body;" > can receive </span><span style= "FONT-FAMILY:CALIBRI;" >10m</span><span style= "font-family: the song Body;" > Broadband </span><span style= "Font-family:calibri;" >+</span><span style= "font-family: the song Body;" > TV set-top box. More offers </span><span style= "Font-family:calibri;" >30012</span><span style= "font-family: the song Body;" > or broadband reservation phone </span><span style= "FONT-FAMILY:CALIBRI;" >158******</span><span style= "font-family: the song Body;" Whether the consultation meets the eligibility criteria. </span><aname= "_goback" ></a></p><p> </p>
After conversion:
"XXX Company" you have a XX has not been collected! Use 8G package 18 to receive 50M broadband, 18 yuan to receive 10M Broadband + TV set-top box. For more offers, see the 30012 or broadband reservation telephone 158****** For more information on eligibility.
Oracle CLOB field Strip HTML tags