This function returns a specific part of a text by setting the start index and the end index of the text to be returned.
substring(text, startIndex, endIndex) #Output: Text
You are viewing an old version of this page. View the current version.
Compare with Current View Page History
« Previous Version 13 Next »
This function returns a specific part of a text by setting the start index and the end index of the text to be returned.
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 |
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
Powered by Atlassian Confluence 8.5.7, themed by Refined 7.5.3 and Decadis AG