Function Index

Left

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.

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”