Overwrites a substring of a string with another
Syntax
Usage
Mid( text, start ) = expression
Or
Mid( text, start, length ) = expression
Parameters
text
The string to work with.
start
The start position in text of the substring to overwrite.
length
The number of characters to overwrite.
Description
Copies a maximum of
length characters of
expression into
text, starting at
start.
If
length is not specified, all of
expression is copied. The size of the string
text is unchanged; if
expression is too big, as much of it is copied up to the end of
text.
Mid can also be used as a function to return part of another string. See
Mid (Function).
Example
Dim text As String
text = "abc 123"
Print text 'displays "abc 123"
' replace part of text with another string
Mid(text, 5, 3) = "456"
Print text 'displays "abc 456"
Differences from QB
See also