INDEXOF
Usage
Use this function to get the index (1-based) of searched text. If text is not found -1 is returned.
| Category | Function | Type | Where to use | Argument statement |
|---|---|---|---|---|
| FUNCTION | SERVER STORAGE | STRING | .VALUE |
Syntax
1 | |
Arguments
Parameter_1
value where to search Parameter_2: any column field value (#Storage_Name.Field_Name.VALUE or .OLDVALUE), constant between quotation marks ("constant"), System Variables or function-returned value
Parameter_2
searched value: any column field value (#Storage_Name.Field_Name.VALUE or .OLDVALUE), constant between quotation marks ("constant"), System Variables or function-returned value
Position (optional)
position where the search will start
Note
This function is not key sensitive
Return Value
Integer
Examples
Example 1
Formula
=INDEXOF("Welcome to ELEGERE"; "eLegere")
Description
Return the position where eLegere starts in the string Welcome to ELEGERE
Result
11
Example 2
Formula
=INDEXOF(#Software.Description.VALUE; "eLegere"; 5)
Description
Return the position where eLegere starts in the column Description of Storage Software starting from position 5
Result
Integer