substr(string, start [, length])


Description

Extracts a portion of the string. The string may reference text values in any folder or the string may be a fixed value.
Start sets the starting position for the extraction with 1 being the first position.
Length is optional. If left off then the extraction is from the starting position to the end and if the length exceeds the end of the string then extraction is from the start to the end of the string.

Examples

substr("Hello World",1)
returns Hello World
substr("Hello World",1,5)
returns Hello
substr("Hello World",7,5)
returns World
substr(ITT,1,2)
returns the first two charactrers of the item text

Related Rules

right(), left()