Skip to main content

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)