SEARCH() : find the position of a text (case-insensitive) – TimeTonic v7 - EN

The SEARCH() function returns the position of a text within a string, ignoring uppercase and lowercase: it returns a number representing the position of the text. It is ideal for searching for a word in free text entered by a user, when the spelling may vary.

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

Syntax

SEARCH(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-insensitive).

2 texte_dans_quel_se_trouve String in which to search.

3 position_début Start position (1 = beginning).

Example

Search for a text regardless of case

"ban" searched in "Banane" becomes "1" (the search ignores case, so "Ban" is found at the beginning).

SEARCH("ban", "Banane", 1)

Use FIND() for a case-sensitive search. Returns 0 if texte_cherché is not found.

Comparison table

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

Go further

FIND()

Returns the position of a text within a string, taking case into account.

Read more →

Or continue with

Formula glossary

All available operators and functions, sorted by category.