Text
The text string containing a part to extract.
StartIndex
The position in the text string marking the start of the part to be returned. The first character has position 1.
Length
The number of characters to include. If omitted, the rest of the text string is returned, starting at the given start position.
Returns
The sought text from the given text string.
Returns text from any part of a text string, effectively returning a substring. MID ("abcd", 2) MID ("abcd"; 2) returns "bcd", the characters of "abcd" starting at position 2. MID ("abcd", 2, 2) MID ("abcd"; 2; 2) returns "bc", two characters from "abcd" starting at position 2.
Consider using the CHARAT function instead if you need to extract a single character.
Examples
Returns "a", the first character of "abcd".
Returns "ab", the first two characters of "abcd".
Returns "bc", two characters of "abcd" starting with "b".
Returns "bcd", the characters of "abcd" starting at position 2.
Returns "bc", two characters from "abcd" starting at position 2.