Human Resources and ELM - PSFT (MOSC)

MOSC Banner

Query Manager - REGEXP_REPLACE

edited Mar 30, 2022 1:40PM in Human Resources and ELM - PSFT (MOSC) 2 commentsAnswered

I'm trying to remove HTML tags in a query. We need to use Query Manager, so our ePerformance admins can monitor. I've tried this expression, but doesn't seem to work. EP_RESULTS is the long description field. Expression type is Long Description, with the Aggregate checkbox selected. What am I doing wrong? Do I need to use this as a field too?

REGEXP_REPLACE(I.EP_RESULTS, '<[^>]*>|&npsb;|& npsb;', ' ')

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center