SUBSTRING
Takes a slice of a text

Description

Returns a slice of the given text between the given indices.
The slice of text starts at (and includes) the index given as the 2nd parameter. It ends at (and excludes) the index given as the 3rd parameter.
If both indices are the same, the function returns an empty text. Negative indices are counted backwards, starting from the end of the text.

Function signature

1
SUBSTRING(text: String, start: Number, stop: Number) => String
Copied!
Parameter
Description
Text
Text which to get a slice from
Start
The index (starting from 0) indicating the first character to include.
Stop
The index (starting from 0) indicating the end of the slice. This character will not be included in the result.If omitted, then the rest of the text will be included.

Examples

Formula
Return value
SUBSTRING("foo bar", 0, 3)
foo
SUBSTRING("foo bar", 4)
bar
SUBSTRING("foo bar", 0, -1)
foo ba
Last modified 1yr ago
Export as PDF
Copy link