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] )

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