FIND
Finds the index of a substring within a string
Last updated
Finds the index of a substring within a string
Last updated
FIND( string
, substring
, [start index]
)
Finds and returns the index of a substring
within a string
; returns 0 ifsubstring
is not found.
The index of a substring
within a string; outputs 0 if the string is not found.
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.
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.