SEARCH
The SEARCH function searches for the first position of a specified string within another string. If the specified string is not found, the function returns 0. You can also specify a starting position from which to begin the search.
Syntax
int SEARCH(string searchText, string value)
int SEARCH(string searchText, string value, int start)
Input
Object | Data Type | Description |
---|---|---|
value | String | The string to look in. |
searchText | String | The string to find. |
start | Integer | The position to start from (1 is the first position). |
Example
Here's an example of using the SEARCH function to find the position of a substring within a string:
SEARCH("world", "hello world")
This would return 6, because the substring "world" begins at the 6th position in the string "hello world".
You can also specify a starting position for the search. For example, to search for the substring Simego starting from the 8th position in the string "Company: Simego" you would use the following:
SEARCH("Simego","Company: Simego",8 )
This would return "2" as "Simego" starts at the second position after the 8th position in the string.