FIND
Syntax
FIND (string_expression, search_string)
Description
Returns the starting position of a string of any length within string_expression.
Arguments
| string_expression | The string to search. |
| search_string | The string characters to find within the string. |
Returns
The starting position of the search_string as an Integer32.
Remarks
If search_string is not found, FIND returns a 0.
Example
If MyEntity.FileName contains a value of "C:\Documents\Scribe", the following formula:
FIND(MyEntity.FileName, "Documents")
Returns: 4, which is the starting position of the word Documents