The FIND function searches for the first occurrence of a text value within another one. If the text contains the specified characters, the function returns a number. This number indicates the position of the first occurrence of the text value searched for.
For example, you can use FIND to identify items that contain a specific product name.
FIND(Text to find, Text to search [, Starting character])
|Text to find (required)||Text||The text value to locate in the Text to search argument.|
|Text to search (required)||Text||The text value to search within for an instance of the Text to find argument.|
The position to start the search from. Includes spaces.
Does not affect the numeric result the FIND function returns.
The FIND function returns a numeric result.
If the FIND function does not find an instance for the Text to find argument, it returns a value of 0.
The FIND function is case-sensitive. This means that if the Text to search argument contains the Text to find argument with different capitalization, the FIND function returns a value of 0.
The FIND function considers spaces to be a character like letters or numbers.
The FIND function only looks for exact text matches. It is not possible to use search patterns such as regular expressions or wildcards.
If you use emoji with the FIND function, the result of the function can be incorrect.
In Polaris, the FIND function considers the length of all Unicode characters to be one. This means that the FIND function returns the correct starting character.
In the Classic Engine, the FIND function considers the length of:
- Unicode characters from within the Basic Multilingual Plane (BMP) to be 1
- Unicode characters from outside the BMP to be 2
- The length of composite characters (such as those with accents or diacritic marks) to be equal to the number of components
In this example, a module has a Companies list on columns. There are two line items on rows. The first contain several company names. The second contains a formula that uses the FIND function.
|Company 1||Company 2||Company 3||Company 4|
|Company Name||Imperial ABC ltd||Imperial abc ltd||ABC ltd||Company ABC|
Character that ABC starts at
In this example, the FIND function looks for the text string ABC, starting from the 4th character. It returns a result of 0 for the text string Imperial abc ltd because the string abc is not capitalized. It returns a result of 0 for the text string ABC ltd because ABC is within the first four characters.