Function reference
Obtains a specified number of characters from the beginning of a string.
Left ( string, n )
| Argument | Description |
| string | The string containing the characters you want |
| n | A long specifying the number of characters you want |
Returns
Data type: String
Returns the leftmost n characters in string if it succeeds and the empty string (“”) if an error occurs.
If n is greater than or equal to the length of the string, Left returns the entire string. It does not add spaces to make the return value’s length equal to n.
Example 1
This expression returns BABE:
Left(‘BABE RUTH’, 4)
Example 2
This expression returns BABE RUTH:
Left(‘BABE RUTH’, 40)
Last modified:
23 May 2021
Post your comment on this topic.