Name
Mid, MidB Functions
Syntax
Mid(string
,start
[,length
])
-
string
Use: Required
Data Subtype: String
The expression from which to return a substring.
-
start
Use: Required
Data Subtype: Long
The starting position of the substring.
-
length
Use: Optional
Data Subtype: Long
The length of the substring.
Return Value
A Variant of subtype String.
Description
Returns a substring of a specified length from within a given string.
Rules at a Glance
If
string
contains aNull
,Mid
returnsNull
.If
start
is more than the length ofstring
, a zero-length string is returned.If
start
is less than zero, error 5, “Invalid procedure call or argument,” is generated.If
length
is omitted, orlength
is greater than the length ofstring
, all characters fromstart
to the end ofstring
are returned.The
MidB
version of theMid
function is used with byte data held within a string. When usingMidB
, bothstart
andlength
refer to numbers of bytes as opposed to numbers of characters.
Example
The following example is a function that parses a string passed to it
as a paramater and writes each word to a dynamic array. Note the use
of the InStr
function to determine the position
of a space, the character that can terminate a word, in this case:
Public Function ParseString(strString) Dim arr( ) Dim intStart, intEnd, intStrLen, intCtr intCtr = 0 intStart = 1 intStrLen = Len(strString) Redim Preserve arr(10) Do While intStart > 0 intEnd = InStr(intStart, strString, " ") - 1 If intEnd <= 0 Then intEnd = intStrLen If intCtr > UBound(arr) ...
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.