Returns the position of a text string (“FindText”) within another text string (“WithinText”).
Search starts at first character by default. (Otherwise, search starts at the character at Position.)
Search is case-sensitive by default. (Otherwise, enter False for the CaseSensitive argument.)
Syntax
FIND (“FindText”, “WithinText”, [Position], [CaseSensitive?])
Note: The required separator (comma or semi-colon) automatically corresponds to your computer’s location settings.
Data Types of the Arguments
All Texts: String
Starting Position (Optional): Integer
Case-sensitive? (Optional): True/False
Data Type of the Result
Integer
Example
Find the position of the dash character within the Element ID (e.g. “DOO - 007”).
Expression
FIND (“-”, Element ID)
Result
5 (for an Element ID of “DOO - 007”)