General
The Substring function can be used to extract characters from a String.
Syntax
The syntax of the Substring function is:
Left Function Syntax
Left(<value>, <first_character_index>, <length>)
The character index is zero-based (the first character has an index of 0).
Examples
The following Expression returns a String that contains 3 characters starting from the second character of the value of variable vTest of a Datasource named Consumer Sales:
Substring Function Example
Substring([Datasource].[Consumer Sales].[Variable].[vTest], 1, 3)