Mid$ Function/Assignment
Syntax
-or-
Mid[$](strvar, Index[, Len]) = S$
Group
Description
Function: Return the substring of S$ starting at Index for Len chars.
Instruction: Assign S$ to the substring in strvar starting at Index for Len chars.
Note: A similar function, MidB, returns the Len bytes starting a byte Index.
Parameter |
Description (Mid Function) |
Copy chars from this string value. If this value is Null then Null is returned. |
|
Start copying chars starting at this index value. If the string is not that long then return a null string. |
|
Copy this many chars. If the S$ does not have that many chars starting at Index then copy the remainder of S$. |
Parameter |
Description (Mid Assignment) |
Change part of this string. |
|
Change strvar starting at this index value. If the string is not that long then it is not changed. |
|
The number of chars copied is smallest of: the value of Len, the length of S$ and the remaining length of strvar. (If this value is omitted then the number of chars copied is the smallest of: the length of S$ and the remaining length of strvar.) |
|
Copy chars from this string value. |
See Also
InStr( ), Left$( ), Len( ), Replace$( ), Right$( )
Example
Sub Main
S$ = "Hello There"
Mid$(S$,7) = "?????????"
Debug.Print S$ '"Hello ?????"
Debug.Print Mid$("Hello",2,1) '"e"
End Sub