substring()

This function returns a specific part of a text by setting the start index and the end index of the text to be returned.

syntax

substring(text, startIndex, endIndex) #Output: Text

Parser expression	Description
substring("smiles", 1, 5)	This example returns the following text: "mile"
substring("Hamburger", 0, 3)	This example returns the following text: "Ham".

Parameters used in this function

Parameter	Input (data type)	Description
`text`	TEXT	Any given text.
`startIndex`	NUMBER	A number that specifies the index of the first character for the substring. The index starts at 0.
`endIndex`	NUMBER	A number that specifies the index-1 of the last character for the substring. The length of the substring is endIndex - startIndex.

This function returns a TEXT