Hello All
I have a requirement to convert the contents of a column (actually two columns one is CLOB and the other is VARCHAR) into readable text. Both these columns store exactly the same information, the difference being only the data types. So I can use either of them for extracting the text.
I tried using REPLACE but there are so many that this will surely affect performance and at the end of it I might not have covered every single tag.
Some example of these tags are
<!-- RICH TEXT -->
<font color="#ff0000>
<div> etc and so many more!
Some of the data in this column is as attached.
Is there a way to do this i.e. extract only the text part of the content and discard the rest?
Any suggestions will be much appreciated.
Regards
Praveen