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. 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
Create a Mobile Website
View Site in Mobile | Classic
Share by: