Description
Replaces a specified number of characters in a string variable with characters from another string.
Syntax
Mid(stringvar,start[,length]) =string
The Mid statement syntax has these parts:
Part |
Description |
stringvar |
Name of string variable to modify. |
start |
Character position in stringvar where the replacement of text begins. |
length |
Number of characters to replace. If omitted, all of string is used. |
string |
String expression that replaces part of stringvar. |
Remarks
The number of characters replaced is always less than or equal to the number of characters in stringvar.
See Also
Mid Function.
Example
This example uses the Mid statement to replace a specified number of characters in a string variable with characters from another string.
MyString = "The dog jumps" ' Initialize string. Mid(MyString, 5, 3) = "fox" ' MyString = "The fox jumps". Mid(MyString, 5) = "cow" ' MyString = "The cow jumps". Mid(MyString, 5) = "cow jumped over" ' MyString = "The cow jumpe". Mid(MyString, 5, 3) = "duck" ' MyString = "The duc jumps".