FIND

FIND returns the position at which a string is first found within a block of text. It distinguishes between upper case and lower case letters. It returns NULL if the string is not found.

Function category: Text

Syntax

FIND( arg0, arg1, [arg2] )

Arguments

Description

arg0

String to search for.

arg1

Block of text to be searched.

[arg2]

Optional. Starting position to begin searching for the string.

See SEARCH.

Example

Let's say we have the following field reference with a string value.

findenginebyid.body.manufacturer = "Remedy Engines"

If we want to find the location of the first occurrence in this string of the letter "d", use the following function.

# Find the location of the first occurences of a string
FIND("d",findenginebyid.body.manufacturer)
# Returns 5
# Letter "d" is located at position 5 in the string "Remedy Engines"

Notes

See also Search, which finds the first appearance of a string within a block of text.