FIND

Syntax

FIND (Text Original String, Text Sub String, Number Starting Position)

Description

Use the FIND function to find a substring in the original string passed in starting from a specified start position in the original string.

Parameters

Parameter	Description
Text Original String	The text of the original string.
Text Sub String	The substring text to find.
Number Starting Position	The start position in the original string.

Returns

The position of the substring in the original string. The index is 1-based.

Example

The following formula finds the account name that begins with Expense:

IF(FIND(ACCOUNT_NAME, "Expense", 1) = 1, #TRUE, #FALSE)