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.

Examples