Find

Syntax

Find(Source: String, SubStr: String, Start: Integer)

Parameters

Source. Source string.

SubStr. Searched substring.

Start. Number of the string, with which search must be started. Optional parameter. The parameter is set to 1 by default.

Description

It returns substring position index in string.

Comments

If the specified substring is not found in the source string, the method returns 0.

If the Start optional parameter is specified, the function ignores all substring instances that appears before position with the Start index.

Character numbering in the string starts with 1.

Search is case-sensitive.

Example

Formula Result Application
= Find("Calculator", "a", 4)

7

Expressions can be used in model formulas of modeling container, in formulas of time series database calculated series, in formulas of the modeling container that is a child one for time series database in formula editor.
= Find("Calculator", "a")

2

See also:

Functions Available in Expression EditorText Functions