MID
Returns a segment of a text.
Syntax
MID(text; startPos; length)
text - The text from which a segment is to be returned - Value type: text
startPos - The position of the first character of the segment within the text - Value type: integer
length - The length of the returned segment in characters - Value type: integer (optional).
Remarks
If length is not defined or startPos + length exceeds the length of the text, MID returns all characters after startPos.
MID returns an empty text ("") if startPos is greater than the length of parameter text or if the parameter length is 0.
