FINDSTR Function
Function Type | Predefined function | |
Syntax | FINDSTR( <stringValue>, <subString> ) | |
Description | Locates the first occurrence of a substring within a specified string. It then returns the position within the string where the substring is found. If the substring is not found, a negative number (-1) is returned. | |
Argument | Description | |
<stringValue> | String value to search. | |
<subString> | Substring value to search for within <stringValue>. | |
Returns | Integer | |
Example | This example returns the integer value 0, since the substring is found at the 0 character position of the string "Flabbergast". FINDSTR("Flabbergast", "Flab") | |
Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*