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
13
Views
2
Comments
edited Jul 14, 2015 8:42PM in Reporting and Analytics Taleo Enterprise 2 comments

Summary

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

Content

Example

 

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.

Register

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