Mid Function
Returns a specified number of characters from a string.
Mid(string, start[, length])
Arguments
string
String expression from which characters are returned. If string contains
Null, Null is returned.
start
Character position in string at which the part to be
taken begins. If start is greater than the number of characters in
string, Mid returns a zero-length string ("").
length
Number of characters to return. If omitted or if there are fewer
than length characters in the text (including the character at
start), all characters from the start position to the end of the
string are returned.
Remarks
To determine the number of characters in string, use the Len
function.
The following example uses the Mid function to return six characters,
beginning with the fourth character, in a string: Dim MyVar
MyVar = Mid("VB Script is fun!", 4, 6) ' MyVar contains "Script".
Note The MidB function is used with byte
data contained in a string. Instead of specifying the number of characters, the
arguments specify numbers of bytes.
|