Skip to Main Content
Forums

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Alternative for INSTR() in OBIEE

Subhadeep GuhaAug 23 2016 — edited Aug 24 2016

I am currently working on a problem whereby I have to parse through a string and split the string into 2 sub strings. My string can have multiple underscore( _ ) and I want the last underscore( _ ) to be the separator between the 2 sub strings.

Example:

If the text is ABC, it should return 'ABC' & NULL.

If it's ABC_12, it should return 'ABC' & '12'

If the text is ABC_12_pqr_97, it should return 'ABC_12_pqr' & '97'.

I tried LOCATE function to find the position of the last underscore but it only gives you the position of the 1st occurrence of the underscore. What I need is the position of the Nth occurrence of that underscore(which basically INSTR() function in SQL does). Is there any alternate way of deriving it?
This post has been answered by Pedro F on Aug 23 2016
Jump to Answer

Comments

630712
Yes you're right.

For more information on how to integrate OWB 11g and OWF check the installation and administration guide:

http://download-uk.oracle.com/docs/cd/B28359_01/owb.111/b31280/install_opts05.htm#i1008852
Asmirnov-Oracle
Hi,

The intallation guide referenced below
http://download-uk.oracle.com/docs/cd/B28359_01/owb.111/b31280/install_opts05.htm#i1008852

states that "For a Warehouse Builder 11g repository on an Oracle 10g Release 2 Database, you must download the Oracle Workflow 2.6.4 software"
But on OTN I was only able to find "Oracle Workflow Server Release 2.6.3 for Microsoft Windows"
Would you be so kind to let me know where from I can download workflow 2.6.4 server?

Thank you.

Anatoliy
630712
Hello Anatoliy,

Check out this thread:

1630776
642003
Thanks for reply .. it becomes clear to me now.
1 - 4
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Sep 21 2016
Added on Aug 23 2016
#business-intelligence-applications, #business-intelligence-foundation, #business-intelligence-suite-enterprise-edition-obiee, #obiee
4 comments
2,388 views