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] )
String to search for.
Block of text to be searched.
Optional. Starting position to begin searching for the string.
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"