syntax:functions:find
This is an old revision of the document!
Find(text, string)
A search function that finds the exact position of specific text string in a field or in text. First character has index 1.
The search returns 1 (or other number depending on the position of string in text) in each line the string is found in. If string is not found, the search returns 0.
Both arguments are implicitly converted into text values, if required.
| Example | Result |
|---|---|
| find('Los Angeles', 'Los') | 1 |
Examples using a field name:
| Example | City | Result |
|---|---|---|
| find([Сity],'York') | New York | 5 |
| find([Сity],'York') | Dallas | 0 |
| find([Сity],'York') | York | 1 |
See also
syntax/functions/find.1428074186.txt.gz · Last modified: 2015/04/03 11:16 by elenap