Left
Returns the left part of a text value.
Variants
Left(Text text, Numeric number)
Returns the leftmost number of characters from the text argument.
Parameters
- text
- The text string that contains the characters you want to extract.
- number
- Specifies the number of characters you want to extract.
Returns
Text
Examples
Left("invoice", 3)returns "inv".
Left(Text text, Text delimiter)
Returns the left part of a text value up to but not including the first occurrence of a delimiter value.
Parameters
- text
- The text string that contains the characters you want to extract.
- delimiter
- The delimiter string.
Returns
Text
Remarks
If the text does not include the delimiter, the entire text is returned.
Examples
Left("John Smith", " ")returns "John".Left("test/123", "/")returns "test".Left("test/123", ";")returns "test/123".