Position()
Category: Text
Syntax: Position ( text ; searchString ; start ; occurrence ) |
Parameters:
textAny expression that resolves to a text string in which you want to search.
searchStringAny expression that resolves to a text string for which to search.
startAn integer representing the character number at which to begin searching.
occurrenceAn integer representing which occurrence of searchString to locate. A negative number causes the search to proceed backward from the start character.
Data type returned: Number
Description:
Returns the character number where the searchString is found within the specified text string. If the searchString is not found, the Position() function returns a 0.
In most cases, the Position() function is used to find the first occurrence of some substring within a string. Both the start and occurrence parameters will simply be 1 in such instances.
To find the last occurrence of a substring within a string, set the start parameter to be the length of the string and the occurrence parameter to be -1, indicating that the function should search backward from the end of the string for the first occurrence of the substring.
The Position() function is not case sensitive.
Examples:
Function | Results |
---|---|
Position ("This is a est"; "is"; 1; 1) | Returns 3. |
Position ("This is a test"; "is"; 1; 2) | Returns 6. |
Position ("Let (myString = "This is a test"; Position (myString; " "; Length (myString); -1)) | Returns 10, which is the position of the last space in myString. |
Категории