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
Relevant topics
Replace in String [REPLACE]
Replaces a given number of characters within a string with another string, starting from a specified position. Syntax REPLACE ...
Number from String [STRTONUM]
Extracts numerical character(s) from the initial position in a string. (Only the beginning of the string is considered. Numerical characters ...