Find - Anlytic

Returns the position at which a substring is first found within a text value (case-sensitive). Returns 0 when the substring is not found. Category: text Syntax:

Find([text_column], "substring")

Returns: IntColumn Context Filtering: ✓ Yes

Parameters

Name	Type	Required	Description
`string`	`text\|column`	✓ Yes	The text to search.
`substring`	`text\|column`	✓ Yes	The text to search with.

Allowed Column Types: STRING, TEXT

Validation

Minimum parameters: 2
Maximum parameters: 2

Examples

Find([Email], "@")

Returns the position of the first @ in each email address.

Contains - Test whether a substring is present at all
Replace - Replace the substring once it is found
Len - Count the characters in a text value

Last modified on August 17, 2026