Syntax Error While Using Evaluate in OTBI Analysis
SummaryEvaluate function generates a syntax error when using REGXP_SUBSTR
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.