syntax:functions:find
This is an old revision of the document!
Find(text, string)
A search function that finds the position of specific text string in a field or in text. First character has index 1.
The search returns 1 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 |
To use with a field, when FieldA = city:
| Example | FieldA | Result |
|---|---|---|
| find([city],'York') | New York | 5 |
| find([city],'York') | Dallas | 0 |
| find([city],'York') | York | 1 |
See also
syntax/functions/find.1428072234.txt.gz · Last modified: 2015/04/03 10:43 by elenap