Mid(Source: String, Start: Integer, Length: Integer)
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.
It returns a substring of the specified length that starts with the specified position of source string.
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.
| 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: