FIND( )
Finds the location of a substring in a string.
Syntax
FIND(strToFind, str)
FIND(strToFind, str, startPosition)
Arguments
strToFind
The substring to search for. The search is case‑sensitive.
str
The string in which to search.
startPosition
The position in str where the search starts.
Returns
The numerical position of the substring in the string. The first character of a string starts at 1. If the substring is not found, FIND( ) returns 0.
Example
The following example searches for the substring, Ford, in each ProductName value. If the product name is 1969 Ford Falcon, FIND( ) returns 6.
FIND("Ford", [ProductName])
The following example searches for the first hyphen (‑) in each product code. If the product code is ModelA‑1234‑567, FIND( ) returns 7.
FIND("‑", [ProductCode])
The following example uses FIND( ) in conjunction with the LEFT( ) function to display the characters preceding the hyphen in a product code. The LEFT( ) function extracts a substring of a specified length, starting from the first character. In this example, the length of the substring to display is equal to the numerical position of the hyphen character.
LEFT([ProductCode], FIND("‑", [ProductCode]))
If the product code is ModelA‑1234, LEFT( ) returns the following string:
ModelA