MID Function

Returns the specified portion of a string expression


MID( Text T,Integer Start,Integer Length)

Return value:



Text: Any string expression that you want to modify.

Start: Numeric expression that indicates the character position within the string where the string portion to return begins.

Length: Numeric expression that returns the number of characters that you want to return.


Returns the characters from T, starting at character position Start, for up to Length characters. For the integer conversions, Start=INT(Start), and Length=INT(Length). If there are less than Length characters starting at start, it returns as many characters as it can beginning with Start. In particular, if Start > LEN(T), it returns the empty string (""). If Start < 0, it returns an Error. If Start >=0, and Length=0, it returns the empty string.

Note: MID(T,1,Length) produces the same results as LEFT(T,Length).


=MID("output",4,3) returns put.

Trademarks | IBM Connections wiki