Mid
The Mid function returns a specified number of characters from a string.
Syntax :
Mid(string,start,[length])| Parameters | 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. |
Example :
Return 1 character, starting at position 1.
s = Mid(" Testimonial ",2,6)Result :
s=Testim