Mid$ Function/Assignment
Syntax
Mid[$](S$, Index[,
Len])
-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) |
---|---|
S$ | Copy chars from this string value. If this value is Null then Null is returned. |
Index | Start copying chars starting at this index value. If the string is not that long then return a null string. |
Len | 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) |
---|---|
strvar | Change part of this string. |
Index | Change strvar starting at this index value. If the string is not that long then it is not changed. |
Len | 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.) |
S$ | 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