Find Function
Description:
The position, from a starting position, of a sub-text (case-sensitive) within a text.
The function returns -1 if the sub-text does not occur.
Returns:
Whole Number
Parameters:
Parameter | Data Type | Description |
|---|---|---|
1 | Text | The sub-text. |
2 | Text | The text. |
3 | Whole Number | The starting position. |
Examples:
Expression | Result |
|---|---|
Find( "bc", "abcabc", 1 ) | 2 |
Find( "bc", "abcabc", 3 ) | 5 |
Find( "bcd", "abcabc", 1 ) | -1 |
Related Content
-
Text Functions
Format:
Article,
1 min read