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 1
Substring('Formula Manager', 8, 7) Returns 'Manager'
Example 2
Substring('Formula Manager', 3) Returns 'mula Manager'
Parameters
| Name | Type | Description | Required |
|---|---|---|---|
| inputstring | xxxx | xxxx | xxxx |
| startposition | xxxx | xxxx | xxxx |
| length | xxxx | xxxx | xxxx |