Left

Description

Left returns characters from the left side of text.

Syntax

Left(text, length)

Parameters

Parameter	Required	Type	Description
text	Yes	String, field, or expression	Source text.
length	Yes	Integer	Number of characters to return.

Notes

Use this function in calculated fields, metric expressions, or query expressions where the function category is supported.

Example

Left(ProductCode, 3)

The expression returns the calculated result according to the current query context.