Examples

FIND("a", "abc") : 1

FIND("bc", "abc") : 2

FIND("d", "abc") : 0

FIND("Red", "I'm bored!") returns 0 because Red--with an uppercase R--doesn't occur in I'm bored!.

FIND(UPPER("Red"), UPPER("I'm bored!")) returns 7 because the all-uppercase RED occurs at that position in the all-uppercase I'M BORED!.

FIND("@", [Email]) returns the position of the first at sign (@) in Email, or 0 if not present.

Syntax

FIND( needle , haystack )

Arguments

needle (any) : The text fragment to find in search value (haystack).

haystack (any) : The text value in which the text fragment (needle) is to be sought.

Return Value

Number : The position in the search value (haystack) at which the fragment (needle) was found, or zero (0) if not found. Note that the search is case-sensitive: upper- and lower-case letters are different.

See Also

CONTAINS(), IN()

Did this answer your question?