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