Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
Return the left, and right sides of a variable separately — Cloud Customer Connect
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

Return the left, and right sides of a variable separately

Accepted answer
edited Jul 14, 2015 8:42PM in Reporting and Analytics Taleo Enterprise 2 comments


i need to return the numbers of the cost center, and then the description in the next column




for the left side in OBI 

=Left([Open Reqs].[Req. Organization Level 5];4)

in order to just return the first 4 numbers


for returning the right before the first 5 spaces i had to create a variable 

=Length([Open Reqs].[Req. Organization Level 5])

then apply the variable to return the cost center name 

=Right([Open Reqs].[Req. Organization Level 5];[_m_len]-5)

Not sure how to do this in BO....any ideas? Thank you!!

Howdy, Stranger!

Log In

To view full details, sign in.


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