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.length
can 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 |