1) Try to extract everything between end html tag(>)and next starting html tag (<)
2) First approach becomes complicated when you have nested tags. So the solution is to replace everything that is between (<) and (>)
SQL below replaces all the tags with space.
Select Regexp_Replace('<
*Note: just put some tags between <> to test, google is not displaying the tags properly. The inner tags (before and after bold ) simulate nested tags.
This is good, but how do you replace special characters of html tags like  , " and many more.
ReplyDeletesince  ," are constants, you can either use replace or regexp_replace
ReplyDeleteregexp_replace(source_string,'[ ]|["]','')