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

Take this text as an 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

Parser expression

Description

substring("HAMBURGERS ARE DELICIOUS", 11, 14)

This example returns

ARE

substring("HAMBURGERS ARE DELICIOUS", 15, 24)

This example returns

DELICIOUS

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.

This function returns a TEXT

Use cases and examples

Use case	Workflow function	Parser functions
Set custom IDs for each issue	Set or create JWT project property Update or copy field values	length() projectProperty() substring() toNumber() year()
Set the next fix version	Update or copy field values	floor() toNumber() substring() length()
Shorten the summary to a maximum number of characters	Update or copy field values	substring() length()
Calculate custom sequence numbers	Update or copy field values Set or create JWT project property	toUpperCase() substring() length() projectProperty() toNumber()