MID$ returns  returns the specified number of characters starting at Position% of the argument string value.

Syntax

MID$(StrExpr$, Position%, [Length%])

Arguments

• StrExpr$ is a string expression
• Position% is the starting position of the substring 
• Length% is an optional integer value containing the number of characters for the substring to contain

Remarks

1. NullString is considered as a DETERMINED empty string 
2. If Length% is omitted, the full remaining part of the string is adopted.

Examples

MID$("NullString", 3, 1) returns "NullString"MID$("Qnowledge Wageningen", 8,

6) returns "ge Wag"MID$

("Qnowledge Wageningen", 8) returns "ge Wageningen"MID$("Qnowledge Wageningen", 8, 50)

 returns "ge Wageningen"

Quick links: Function overview | Attribute overview | Constants overview | Dimensions overview