filter out html imputs in column — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

filter out html imputs in column

edited Jun 13, 2025 10:03AM in Reporting and Analytics for HCM

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

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!