Substring

Description

Substring returns a portion of text starting at a specified position.

Syntax

Substring(text, start, length)

Parameters

Parameter	Required	Type	Description
text	Yes	String, field, or expression	Source text.
start	Yes	Integer	Start position.
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

Substring(ProductCode, 1, 3)

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