FIND Operation
How to use the FIND operation for Computed Attributes
Definition
The FIND operation finds the first position of a string found in a text and is case sensitive.
Example
FIND('e','Hello There!')
Result:
2
If the formula doesn't find any instances, the result is NULL.
Syntax Guide
FIND(search_for, text_to_search, [starting_at])
search_for - The string to look for within text_to_search
text_to_search - The text to search for the first occurrence of search_for
starting_at - [ OPTIONAL - 1 by default ] - The character within text_to_search at which to start the search