Skip to main content
Version: I2023.4.1

Left

Syntax​

LEFT(String, length)

Input Parameters​

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

Length (Required)
A numeric expression indicating the number of characters to return. If 0, a zero-length string ("") is returned. If greater than or equal to the number of characters in string, the entire string is returned.

Return Value​

Returns a String containing a specified number of characters from the left side of a string.

Example​

Return the left 4 characters from the member's name.

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