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
Get Started with Redwood for Oracle Cloud HCM   Begin Now

Need to Split Job.Job Name into 3 different fields - Primary, Secondary, Teritiary

in Reporting and Analytics for HCM 7 comments

Summary: OTBI Field : "Job"."Job Name" contains values like mentioned below. I would like to split them as
Primary Secondary Tertiary
Unmapped Unmapped HEAD OF AGRICULTURE POLICY DIVISION
Science and Engineering Inspectorate MARINE SURVEY AND FISHING TECHNOLOGY SCIENTIST
Science and Engineering Ecology SENIOR FISHERIES BIOLOGIST

How do I achieve this in OTBI formula??

Content (please ensure you mask any confidential information):
"Job"."Job Name"
Unmapped.Unmapped.HEAD OF AGRICULTURE POLICY DIVISION
Science and Engineering.Inspectorate.MARINE SURVEY AND FISHING TECHNOLOGY SCIENTIST
Science and Engineering.Ecology.SENIOR FISHERIES BIOLOGIST

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!