String from Position [MID]

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

  • Was this Helpful ?
  • YesNo