1. Calculation functions
  2. All Functions
  3. Text Functions
  4. FIND

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.

Syntax

FIND(Text to find, Text to search, Starting character)

Arguments

ArgumentData typeDescription
Text to find (required)TextThe text value to locate in the Text to search argument.
Text to search (required)TextThe text value to search within for an instance of the Text to find argument.
Starting positionNumber

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.

Syntax example

FIND("Ltd.", Companies) 

Additional information

Search behavior

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.

Constraints

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.

Excel equivalent

Related Anaplan functions

FINDITEM

Examples

General example of FIND

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 1Company 2Company 3Company 4
Company NameImperial ABC ltdImperial abc ltdABC ltdCompany ABC

Character that ABC starts at

FIND("ABC", Company Name, 4)

10009

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.