The Mid function returns a specified number of characters from a string.
Tip: Use the Len function to determine the number of characters in a string.
Parameter | Description |
---|---|
string | Required. The string expression from which characters are returned |
start | Required. Specifies the starting position. If set to greater than the number of characters in string, it returns an empty string ("") |
length | Optional. The number of characters to return |
Return 1 character, starting at postion 1:
The output of the code above will be:
Return 15 characters, starting at postion 1:
The output of the code above will be:
Return all characters, starting at postion 1:
The output of the code above will be:
Return all characters, starting at postion 12:
The output of the code above will be: