Talents Comments Field Reporting
Hello experts,
We have at 10 talents reports that using the comments fields, but it are stored as "CLOB" but is a mess to work with it.
i try a lot of diferent forms to clean it, my actual line is:
TRIM(
REGEXP_REPLACE(
REGEXP_REPLACE(
REGEXP_REPLACE(
REGEXP_REPLACE(
REGEXP_REPLACE(
REGEXP_REPLACE(
REPLACE(REPLACE(REPLACE(
DBMS_LOB.SUBSTR(HCPI.COMMENTS, 3950, 1),
' ', ' '),
'&', '&'),
'"', '"'),
'<(script|style)[^>]>.?</\1>', ' ', 1, 0, 'in'),
'<[^<>]+?>', ' ', 1, 0, 'i'),
'&[^;]+;', ' ', 1, 0, 'i'),
'\s+', ' ', 1, 0, 'i'),
CHR(10), ' '),
CHR(13), ' ')