Returns a segment of a text.


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).


  • 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.