Get Started: AI Resources for Oracle Cloud HCM – Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
filter out html imputs in column
Summary:
Im making a reporting for talent and need to filter out de html inputs in the Description field of the table HRT_CAREER_STATEMENT_ITEMS_V.
is there a better way?
(CASE
WHEN HCSI.DESCRIPTION IS NULL
OR LENGTH(
TRIM(
REPLACE(
REPLACE(
REGEXP_REPLACE(
SUBSTR(HCSI.DESCRIPTION, 1, 350),
'[^0-9A-Za-z]', ' '
),
' p ', ''
),
'nbsp', ''
)
)
) = 0
THEN 'No comments'
ELSE
TO_CHAR(
TRIM(
REPLACE(
REPLACE(
REGEXP_REPLACE(
SUBSTR(HCSI.DESCRIPTION, 1, 350),
'[^0-9A-Za-z]', ' '
),
' p ', ''
),
'nbsp', ''
)
)
)
END) CAREER_STATEMENT
0