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!

Discoverer INSTR Function does not recognize a Hyphen in the Oppty ID

796707Sep 8 2010 — edited Sep 9 2010

I need to identify IDs that have a number that proceeds a hyphen. INSTR(Opportunity ID,'-',1,1) calculation identifies the location of the hyphen for most of the IDs. However, it is not recognizing the hyphen in some. For those IDs that have hyphens that are not recognized, I do know that the hyphen is counted as a character because Discover includes the hyphen when I use a LENGTH function calculation on the ID field.

Example:
INSTR(ID Field,'-',1,1) calculation for ID 3-XXXXX1 = 2; but for ID 3-XXXXX2 = 0.
LENGTH(ID Field) calculations for both IDs = 8.

Has anyone ever encountered this issue and found a resolution?

Any help would be greatly appreciated ... Thanks!

Edited by: user740605 on Sep 8, 2010 1:43 PM

Edited by: user740605 on Sep 8, 2010 1:45 PM

Edited by: user740605 on Sep 8, 2010 1:47 PM

Edited by: user740605 on Sep 8, 2010 1:47 PM

This post has been answered by Rod West on Sep 9 2010

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 7 2010

Added on Sep 8 2010

#business-intelligence-applications, #business-intelligence-foundation, #discoverer, #function

1 comment

899 views