Description

 

Return a portion of a string.

 

Syntax

 

s = MID$(StringExpression, Start [, Length])

 

Returns

 

String

 

Parameters

 

 

Remarks

 

If Length is omitted, or there are fewer than length characters to the right of the Start character of StringExpression, all remaining characters of StringExpression, including the Start character, are returned.

If Start is negative, the starting position is assumed to be Start characters from the end of the string.

 

Restrictions

 

If Start evaluates to a position outside of the string on either side, or if Start is zero, an empty string is returned.

If Length is negative, all characters from start position to the end of the string are returned.

 

See also

 

String Handling, MID$, LEFT$, RIGHT$,

 

Examples

 

Thanks to Abraxas for the following script example

' Usage of the LEFT$ Keyword example

' Usage of the MID$ Keyword example

' Usage of the RIGHT$ Keyword example

 

Dim MyOLDString   As String VALUE "HELLO WORLD"

Dim MyLEFTString  As String

Dim MyMIDString   As String

Dim MyRIGHTString As String

Dim sMsg          As String

 

MyLEFTString  = LEFT$ (MyOLDString, 4) 

MyMIDString   = MID$  (MyOLDString, 4, 2) 

MyRIGHTString = RIGHT$(MyOLDString, 5)

 

sMsg += "Normal " & MyOLDString   & $CRLF & $CRLF

sMsg += "LEFT$ "  & MyLEFTString  & $CRLF & $CRLF

sMsg += "MID$ "   & MyMIDString   & $CRLF & $CRLF

sMsg += "RIGHT$ " & MyRIGHTString & $CRLF & $CRLF

 

MSGBOX 0, sMsg