Mid

Syntax

MID(string, start, length)

Input Parameters

String (Required)
String expression from which the rightmost characters are returned. If string is NULL, NULL is returned.

Start (Required)
Integer Character position in string at which the part to be taken begins. If start is greater than the number of characters in string, Mid returns a zero-length string ("").

Length (Optional)
An integer indicating the number of characters to return. If omitted or if there are fewer than length characters in the text (including the character at start), all characters from the start position to the end of the string are returned.

Return Value

Returns a String containing a specified number of characters from a string.

Example

Return the 4 characters from the member's name starting at character 3 as a string.

MID([Order Date Dimension].[Order Retail445].currentMember.NAME, 3, 4)