Functions - Mid

Returns a String containing a specified number of characters from a string.

Syntax

Mid(source, start)
Mid(source, start, length)

Parameters

sourceThe string from which characters are returned.
startThe character position at which the part to be taken begins.
lengthThe number of characters to be taken from the string.

If the length parameter is not given, the function takes all characters from start to the end of the string.

Example

This expression part evaluates to "Bar":

Mid("FooBar", 4)

This expression part evaluates to "oB":

Mid("FooBar", 3, 2)