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.
Parameters:
|
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) |
|
Copy chars from this string value. If this value is Null then Null is returned. |
|
|
Change strvar starting at this index value. If the string is not that long then it is not changed. |
|
|
Copy chars from this string value. |
|
|
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.) |
Example:
Sub Main
S$ = "Hello There"
Mid$(S$,7) = "?????????"
Debug.Print S$ '"Hello ?????"
Debug.Print Mid$("Hello",2,1) '"e"
EndSub
See Also: