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 |