Views:

Description

Returns part of the input string based on a start position and length. 

If you just enter a start position then the length will be automatically set to the length of the remainder of the string.

Signature

Substring('inputstring', startposition, length)

Example

Substring('Formula Manager', 8, 7) Returns 'Manager'

Substring('Formula Manager', 3) Returns 'mula Manager'

Parameters

Name Type Description Required
inputstring xxxx xxxx xxxx
startposition xxxx xxxx xxxx
length xxxx xxxx xxxx

Notes: