Removing HTML codes from a CLOB field not working properly
295115Aug 11 2010 — edited Nov 26 2010Hello everyone
I am doing a conversion from one case management system to a new one and we wanted to bring the case notes in plain text format to the new system. The way we coded the conversion was to do this on the select:
REGEXP_REPLACE(REGEXP_REPLACE(case_text, '<[^>]*>', NULL), CHR(38)||'nbsp', NULL)
Where the "case_text" is the CLOB column. The problem is, a few case notes got blank! Because this code stripped everything. Can someone please help me to get a code which will remove only the HTML tags and not the whole text?
Thank you!
Eduardo Ferrari