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
| Argument | Data type | Description |
| 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. |
| Starting position | Number | 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.
Calculation engine functionality differences
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
Syntax example
FIND("Ltd.", Companies)
Additional information
Search behavior
- If the FIND function doesn’t find a case 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 a different capitalization, the FIND function returns a value of 0.
- The FIND function considers spaces to be a character such as 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
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 1 | Company 2 | Company 3 | Company 4 | |
| Company Name | Imperial ABC ltd | Imperial abc ltd | ABC ltd | Company ABC |
Character that ABC starts at
| 10 | 0 | 0 | 9 |
In this example, the FIND function looks for the text string ABC, starting with the 4th character. It returns a result of 0 for the text string Imperial abc ltd because the string abc isn’t capitalized. It returns a result of 0 for the text string ABC ltd because ABC is within the first four characters.
Product serial number parsing
Find the location of the plant’s code to extract logistics routing info.
Source list
Create a Batch Row list with these items:
- Row-001
- Row-002
- Row-003
Result module
Create a Serial Number Diagnostics module with these properties:
- Rows: Batch Row list
- Columns: Line items
- Product Serial Number (Text format)
- TX Plant Starting Position (Number format)
- Assembly Location (Text format)
Enter serial numbers in the Product Serial Number line item.
| Product Serial Number | TX Plant Starting Position
| Assembly Location
| |
| Row-001 | M1-TX-998 | 4 | Texas Assembly Plant |
| Row-002 | M1-tx-998 | 0 | Out-of-State Facility |
| Row-003 | PART_C3_FL_445 | 0 | Out-of-State Facility |
