Mid

Syntax

Mid(Source: String, Start: Integer, Length: Integer)

Parameters

Source. Source string.

Start. Position in the source string, from which the returned substring must start.

Length. The number of characters in the returned string.

Description

It returns a substring of the specified length that starts with the specified position of source string.

Comments

Character numbering in the string starts with 1.

If the Length parameter is set to 0, the returned substring contains all characters in the specified position and to the end of the source string.

Example

Formula Result Application
= Mid("Calculator", 3)

lculator

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.
= Mid("Calculator", 2, 4)

acul  

See also:

Functions Available in Expression Editor │ Text Functions