FIND

Finds the index of a substring within a string

FIND( string, substring , [start index])

Finds and returns the index of a substring within a string; returns 0 ifsubstring is not found.

Arguments

Input	Description
string	Text string(s) to search for substring within
substring	Substring to search for within string
[start index]	Optional, defaults to 0. Index to begin searching for the substring at.

Output

The index of a substring within a string; outputs 0 if the string is not found.

Example

Let's assume we want to extract the state capital from the sentence column. One way to do that would be to utilize FIND({Sentence}, ":") to determine the index the colon is listed at, a unique character always preceding the state capital. Knowing this value for each state, we can now use something like RIGHT() to help us extract the characters associated with the state capitals.