substring
Use the substring function to extract characters from a Text value. You can specify what position in the Text value to extract the characters from, and how many characters to extract. The substring function returns a Text value.
Function format
substring(Text source, Integer index position, Integer length)
- source: the Text value which characters are extracted from.
- index position: the place in the Text source to extract the characters from. The index is zero-based.
- length: the number of characters to extract from the Text source.
substring example
substring("Hello, world!", 7, 5)
The formula returns the Text value world.