Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
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

Syntax Error While Using Evaluate in OTBI Analysis

edited Sep 30, 2019 4:44AM in Reporting and Analytics for ERP 10 comments

Summary

Evaluate function generates a syntax error when using REGXP_SUBSTR

Content

I am attempting to trim the following column in the General Ledger - Journals Real Time subject area: "- Account"."Code Combination Description". By default, this column will result in a value that has all 7 segments concatenated together with a period (ex. General Fund.City Commission.Legislative.Equipment Rental and Lease.Default.Default.Default).

From this concatenated string I want to parse out the values between the 3rd and 4th periods (ex. Equipment Rental and Lease). 

I attempted to use the EVALUATE function with REGXP_SUBSTR to parse out only the necessary information but I continuously receive a syntax error even if I follow the example shown on the screen. I verified my account privileges and I have permission to use the EVALUATE function.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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