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

OTBI - Locating 5th occurrence of character

edited Dec 13, 2022 8:17AM in Reporting and Analytics for SCM 5 comments

Summary:

Several fields have been migrated into one field and need to split into separate columns into OTBI

Content (required):

We need to pick the department from the code combination below.

For eg: if it is PTA01.1100001.0.101.240.616.0.0.0.0.0 then I need to pick only 240 which is our department field which is after the 4th '.'


How can I achieve this in OTBI?

Thank you

Version (include the version you are using, if applicable):


Code Snippet (add any code snippets that support your topic, if applicable):

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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