Returns a number of characters from the beginning of a specified string.
Sample usage
LEFT_TEXT(Campaign, 6)
Syntax
LEFT_TEXT(X, length)
Parameters
X- a field or expression of any type.length- The number of characters to include in the substring.lengthcan be a field, expression, or literal value.
Examples
| Example formula | Input | Output |
|---|---|---|
LEFT_TEXT(Campaign, 6) |
Summer Sale | Summer |
LEFT_TEXT(Campaign, 3) |
Summer Sale | Sum |