Find String [FIND]

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”)

  • Was this Helpful ?
  • YesNo
Relevant topics
Replace in String [REPLACE]
Replaces a given number of characters within a string with another string, starting from a specified position. Syntax REPLACE ...
Convert to String [STR]
Converts a non-unit numeric value or a True/False value into a string. The resulting string shows two decimal places by default. Syntax ...
Number from String [STRTONUM]
Extracts numerical character(s) from the initial position in a string. (Only the beginning of the string is considered. Numerical characters ...