fbpx
Select Page

Returns a substring beginning at the start of a given string.

Usage

Left(<string>,<number>)

string (required) The string from which a left substring will be returned.

number (required) The desired length of the returned substring.

Examples

Left(“Dec. 12, 1950”, 3)
  • Returns “Dec”
Left(“St. Louis”, 20)
  • Returns “St. Louis”
  • If number is greater than the length of string, the result is the original string.
Left(“San Francisco”, -5)
  • Returns “San Fran”
  • If you use a negative number, the result is the string with that number of characters removed from the end.

See Also

Find
Mid
Right

More About Text Functions

Text functions analyze or manipulate string data and are useful sanitizing string input.

When inputting a string, use quotation marks to indicate it as a string. “This is read as a string”

If you would like to include quotes in your string, you can use a slash \ to indicate the following quote is part of the string. “\”This is a string with quotes\”” will display as “This is a string with quotes”

We are rewriting the rules of analytics. Sigma empowers domain experts to join the data conversation, answer the toughest questions, and drive insights.