The SEARCH() function returns the position of a text in a string ignoring case sensitivity.
It is ideal for searching for a word in free text entered by a user, when the writing may vary.
Function name:
SEARCH()
Syntax
SEARCH(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 insensitive). |
text_in_which_is_found |
String in which to perform the search. |
starting_position |
Starting position (1 = beginning). |
Example
SEARCH("ban", "Banana", 1)Result: 1 (the search ignores case, so “Ban” is found at the beginning)
Notes
Use
FIND()for a case-sensitive search.Returns
0iftext_searchedis not found.
Return type
The function returns a number representing the position of the text.
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 |