Any way to use regex in OTBI?
Summary: Is there a way to leverage regex in OTBI in some manner? I have seen methods to leverage it in OBIEE with the following syntax:
EVALUATE('regexp_replace("Activity"."Meeting Minutes",'<div[^>]*>', '') (note - the actual syntax might be wrong here)
I try this, but I see that we're getting a message:
|
|---|
We're encountering an issue where users are pasting HTML content inside the meeting minutes, description fields, etc (specifically long text fields). We're curious if anyone knows if these field types were changed because this suddenly started happening around the second quarter of the year.