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

mile

substring("Hamburger", 0, 3)

This example returns

Ham

Additional information

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.

Have a look at the following example:

0	1	2	3	4	5	6	7	8	9	10	11	12	13	14	15	16	17	18	19	20	21	22	23
H	A	M	B	U	R	G	E	R	S		A	R	E		D	E	L	I	C	I	O	U	S

This function returns a TEXT