Skip to main content

Mid

Mid Function

Returns a specified number of characters from a specified text string, starting at a specified position.

Syntax

Mid (scalar StringValue, scalar StartIndex, scalar Length)

Arguments

ArgumentDescription
scalar StringValueText string to be evaluated
scalar StartIndexPosition (counting from left side of string) that holds the first character to be returned
scalar LengthNumber of characters (counting from the start index) to be returned

Examples:

Mid("Have a nice day !",8,4)

Returns string of specified length from the specified start index in the source string.