OBIEE Online Training

Wednesday, February 20, 2013

LOCATE Function


Hi,

Syntax 
 
LOCATE(strExpr1, strExpr2, integer)
 
Example:   LOCATE('R',"balance_Sheet"."BS_Descr",2)
Where:
 
strExpr1 is any expression that evaluates to a character string. Identifies
the string for which to search.
strExpr2 is any expression that evaluates to a character string. Identifies
the string to be searched.
 
integer is any positive (nonzero) integer that represents the starting
position to begin to look for the character string.

Note:There is no function "LocateN". It is actually the function "Locate" with
another Form

This is explained in Bug 7235397 - LOCATEN STRING FUNCTION DOESN'T WORK IN ANSWERS

Thanks
Deva

No comments:

Post a Comment