How to display Success Criteria Text without HTML tags from Transaction tables
Summary: How to display Success Criteria Text without HTML tags from Transaction tables
We have a requirement to display the Success Criteria Text in the report as plain text (without HTML tags). I am using the below code to extract the Success Criteria from
TABLE(per_bipntf_utility.extractXMLSequenceForEOByName(htd.transaction_id,'oracle.apps.hcm.goals.core.publicModel.entity.GoalEO')) itemrow.
REGEXP_REPLACE(
REGEXP_REPLACE( to_clob(SUBSTR(extract(value(itemrow),'/GoalEORow/SuccessCriteriaText/DATA/text()').getClobVal(),10,LENGTH( extract(value(itemrow),'/GoalEORow/SuccessCriteriaText/DATA/text()').getClobVal() )-12)) , '<[^>]+>', ''), -- remove HTML tags
'&[^;]+;', '' -- remove HTML entities
0