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

Extract first sets of integer from entries

18
Views
8
Comments
edited Mar 17, 2020 6:41PM in General Transactional Reporting (OTBI) 8 comments

Summary

How to extract the first sets of integer from entries in "New Calculated Measure"

Content

Hello Oracle Community,

In "New Calculated Measure" in Analysis, how can a new calculated measure be created to only keep the first set of integers after the letter "D" from the following example:

BEFORE:
ITEM NUMBER
---------------------
ABCD11HIJ150150  
ABCD12EFG152151
ABCD3EFG7230101
ABCD4HIJ2040100
.
.
.


AFTER:
ITEM NUMBER
---------------------
11
12
3
4
.
.
.

The following error occurs when I use "regexp_substr()" function and I do not have administrator access:
[nQSError: 27042] Function regexp_substr is not defined by administrator. (HY000)

Thank you.

Version

Oracle Business Intelligence 11.1.1.9.0
Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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