FIND

From AgileApps Support Wiki
Revision as of 00:53, 4 June 2014 by imported>Aeric
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

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)

Notepad.png

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