Name
Left, LeftB Functions
Syntax
Left(string
,length
)
-
string
Use: Required
Data Subtype: String
The string to be processed.
-
length
Use: Required
Data Subtype: Long
The number of characters to return from the left of the string.
Return Value
Left
and LeftB
return a
variant of subtype String.
Description
Returns a string containing the leftmost
length
characters of
string
.
Rules at a Glance
If
length
is 0, a zero-length string (“”) is returned.If
length
is greater than the length ofstring
,string
is returned.If
length
is less than orNull
, the function generates runtime error 5, “Invalid procedure call or argument,” and runtime error 94, “Invalid use of Null,” respectively.If
string
containsNull
,Left
returnsNull
.Left
processes strings of characters;LeftB
is used to process binary data.
Programming Tips & Gotchas
Use the
Len
function to determine the overall length ofstring
.When you use the
LeftB
function with byte data,length
specifies the number of bytes to return.
VBScript/VB & VBA Differences
There are no Left$
or
LeftB$
functions available in VBScript.
Get VBScript in a Nutshell now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.