Contents x
    Substring
    • 16 Apr 2024
    • 1 Minute to read
    • Dark
      Light
    Contents

    Substring

    • Updated on 16 Apr 2024
    • 1 Minute to read
    • Dark
      Light
    Article summary

    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)

    Was this article helpful?
    What's Next