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​
FIND( arg0, arg1, [arg2] )
Arguments | Description |
| String to search for. |
| Block of text to be searched. |
| Optional. Starting position to begin searching for the string. |
See SEARCH
.
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 stringFIND("d",findenginebyid.body.manufacturer)​# Returns 5# Letter "d" is located at position 5 in the string "Remedy Engines"
See also Search, which finds the first appearance of a string within a block of text.