Remove HTML Tags from a text using SQL

Question

I have column in a table which contains HTML text(data contains HTML tags) and also normal text.

I need to remove the HTML tags in the data wherever it exists.

Steps I planned:

Filter only the records which contains HTML tags. --> I am able to complete this step. My Logic: where HTMLStirng like('<%>%')
Replace HTML tags with a blank space. --> I am trying to apply replace function. But I am not able to.

For Example:

<p>Paragraph</p>
<b>bold</b><I>Italic</I>
Normal Text

My Output shold be:

Paragraph
BoldItalic
Normal Text

Can someone help me in the step 2 ?

I removed the incompatible database tags. Tag your questions only with the database you are actually using. — Gordon Linoff
– Gordon Linoff, Commented Apr 23, 2017 at 13:05
I am trying to apply replace function. But I am not able to. ...why didn't those replacements work for you? — Tim Biegeleisen
– Tim Biegeleisen, Commented Apr 23, 2017 at 13:10
which database are you using, sql server or oracle or anything else? — Aruna
– Aruna, Commented Apr 23, 2017 at 13:15

Jacob · Accepted Answer · 2017-12-07 18:18:58Z

4

If you are using Oracle, try the following

SELECT Regexp_replace(your_column_name, '<.+?>') 
FROM   dual;

Example

SELECT Regexp_replace('<b>bold</b><I>Italic</I> Testing', '<.+?>') 
FROM   dual;

answered Apr 23, 2017 at 16:52

Jacob

14.8k69 gold badges215 silver badges323 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1