LEFT_TEXT

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.

Notes

  • length must be a literal number.

Examples

Example formula Input Output
LEFT_TEXT(Campaign, 6) Summer Sale Summer
LEFT_TEXT(Campaign, 3) Summer Sale Sum

Related resources

Was this helpful?
How can we improve it?