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.
Parameters
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. |
Example
Sub Main S$ = "Hello There" Mid$(S$,7) = "?????????" Debug.Print S$ '"Hello ?????" Debug.Print Mid$("Hello",2,1) '"e" End Sub
See also