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)

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