Substring

Returns the substring of the first argument starting at the position specified in the second argument and the length specified in the third argument. The result is a string.

Function Parameters

Expression

String expression of which substring is to be returned.

Possible children:

  • Data Constant
  • Field reference
  • Function
  • Lookup reference

Start

The letter position at which to start (Integer).

Possible children:

  • Data Constant
  • Field reference
  • Function
  • Lookup reference
Length

The number of letters to return from the start position (Integer).

Possible children:

  • Data Constant
  • Field reference
  • Function
  • Lookup reference