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.