Returns any substring from the middle of a string. The middle is found by scanning the string from right to left, and parameters determine where the middle begins and ends.

Syntax

@MiddleBack( string ; offset ; numberchars )
@MiddleBack( string ; offset ; endstring )
@MiddleBack( string ; startString ; endstring )
@MiddleBack( string ; startString ; numberchars )

Parameters

string

Text or text list. Any string.

Number. A character position in string that indicates where you want the middle to begin, always counting from right to left. The middle begins one character after the offset. Always add 1 to this number; the end of the string is marked by one non-visible character and must be counted in the offset.

Text. A substring of string that indicates where you want the middle to begin, always counting from right to left. The middle begins one character after the end of startString.

Number. The number of characters that you want in the middle. If numberchars is negative, the middle starts at offset or startString and continues from right to left. If numberchars is positive, the middle starts one character past the offset or startString and continues from left to right.

Text. A substring of string that indicates the end of the middle. @MiddleBack returns all the characters between offset and endstring, or between startString and endstring.

If the first parameter is a list, the function operates on each element of the list, and the return value is a list with the same number of elements.

Return value

middle

Text or text list. The substring from the middle of string, which begins at the offset or startString you specify and ends at the endstring you specify, or after the numberchars have been reached.

Locating and extracting substrings
@Begins
@Contains
@Ends
@Left
@LeftBack
@Middle
@Right
@RightBack

Glossary