The FIND() function returns the exact position of a text within a string, strictly respecting uppercase and lowercase letters.
It is used when the match needs to be exact, for example for codes, identifiers, or standardized formats.
Text function name:
FIND()
Syntax
FIND(text_searched, text_in_which_is_found, starting_position)ℹ Calling function parameters in TimeTonic:
- $field_name = field (link, linked table column, number, selection, formula, text...).
- "free text" = free text to be added between quotation marks.
- do not use quotation marks for numbers.
Parameters
| Parameter | Description |
|---|---|
text_searched |
Character or text to search for (case-sensitive). |
text_in_which_is_found |
String in which to perform the search. |
starting_position |
Starting position in text_in_which_is_found (default is 1). |
Example
FIND("A", "BANANA", 1) // Result: 3 (the first occurrence of "A" after position 1)
Notes
The search is case-sensitive, use
SEARCH()if you want to ignore case.If
text_searchedis not found, the function returns0.
Return type
The function returns a number.
The output type format of the result can be configured in the output field options of the formula editor. For more details, see Output format options in the Formula column article.
Comparison table
| Function | Sensitivity | Recommended usage |
|---|---|---|
| FIND() | Case-sensitive | Exact search, controlled data |
| SEARCH() | Case-insensitive | Flexible search, user text |
Best practice
SEARCH() is preferable for user searches or non-standardized data.
FIND() is recommended when case has a specific business meaning.