SUBSTR

Returns a specific sequence of characters from the text.

Sample usage

SUBSTR(Campaign, 1, 6)

Syntax

SUBSTR(X, start_index, length)

Parameters

  • X - A field or expression of any type.
  • start_index - The position from the start of the string from which to begin extracting.
  • length - The number of characters to extract.

Notes

  • The first character of a field is at index 1.
  • To begin extracting from the end of the string, use a negative index. The last character of a string is at index -1, the second to the last is at -2, etc.

Examples

Example formula Input Output
SUBSTR(Campaign, 1, 6) Summer Sale Summer
SUBSTR(Campaign, -4, 4) Summer Sale Sale