FIND() : find the position of a text (case-sensitive)

The FIND() function returns the exact position of a text within a string, strictly respecting uppercase and lowercase: it returns a number. It is used when the match must be exact, for example for codes, identifiers or standardised formats.

The output format of the result is configured in the output field options of the formula editor: see Formula column.

Syntax

FIND(texte_cherché, texte_dans_quel_se_trouve, position_début)

How to reference parameters in TimeTonic: $field_name for a field (link, linked-table column, number, selection, formula, text); "free text" in quotes; no quotes for numbers.

Parameters

# Parameter Description

1 texte_cherché Character or text to search for (case-sensitive).

2 texte_dans_quel_se_trouve String in which to search.

3 position_début Start position in texte_dans_quel_se_trouve (default 1).

Example

Find the exact position of a character

"A" searched in "BANANE" becomes "2" (the first occurrence of "A" from position 1).

FIND("A", "BANANE", 1)

The search is case-sensitive: use SEARCH() if you want to ignore case. If texte_cherché is not found, the function returns 0.

Best practice: SEARCH() is preferable for user searches or non-standardised data. FIND() is recommended when case has a specific business meaning.

Comparison table

Function	Case sensitivity	Recommended use
FIND()	Case-sensitive	Exact search, controlled data
SEARCH()	Case-insensitive	Flexible search, user-entered text

Go further

SEARCH()

Returns the position of a text within a string, ignoring case.

Read more →

Or continue with

Formula glossary

All available operators and functions, sorted by category.