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

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:


Formula syntax is invalid.
[nQSError: 10058] A general error has occurred. (HY000)
[nQSError: 43113] Message returned from OBIS. EVALUATE_SUPPORT_LEVEL inside NQSConfig.INI is not set to support EVALUATE. (HY000)

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.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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