Difference between revisions of "FIND"
From AgileApps Support Wiki
imported>Evelyn m |
imported>Aeric |
||
| (One intermediate revision by the same user not shown) | |||
| Line 3: | Line 3: | ||
;Syntax: | ;Syntax: | ||
FIND(string, searchString, start) | FIND('string', 'searchString', start) | ||
{{:Common:CaseSensitiveSearchString}} | |||
;Return:Number | ;Return:Number | ||
Latest revision as of 00:53, 4 June 2014
The FIND function returns the starting character number of a search string within a specified target string. Optionally, a character number can be specified, which defines the character from which to start. If the character number is not specified, then the search starts from the first character of the string.
- Syntax
FIND('string', 'searchString', start)
Note:
The searchString is case-sensitive. For a case-insensitive search,
use the LOWER function on both the search string and the string being searched.
- Return
- Number
- Example
FIND('street', '123 Maple Street') = 11