Returns a specified number of characters starting from a specified position within a text string.
Syntax
MID (“Text”, Position, NumberOfCharacters)
Note: The required separator (comma or semi-colon) automatically corresponds to your computer’s location settings.
Data Types of the Arguments
Text: String
Starting Position: Integer
Number of Characters: Integer
Data Type of the Result
String
Example
From the given text string, start at the 11th position and return the next five characters.
Expression
MID (“The quick brown fox”, 11, 5)
Result
brown