MID$ 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: Functions overview | Attribute overview | Constants overview | Dimensions overview