Mid
Purpose
Returns a specified number of characters from a string.
Syntax
Mid(string, start[, length])
| Argument | Description |
|---|---|
| string | String expression from which characters are returned. If string contains Null, then 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, then 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, then all characters from the start position to the end of the string are returned. |
Note: To determine the number of
characters in a string, use the Len function.
Example
This 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".| Function | Result |
|---|---|
| Mid("This is the middle of this sentence",9,10) | "the middle" |