MidStr

Returns a part, starting from a specified position and of a specified length, of a specified string expression.

Usage

MidStr("String", Pos, Num)

Where:

String - a string expression where the specified part is to be taken from.

Pos - a numerical expression specifying the position, from the left side of the string, of the starting character of the part to be taken.

Num - a numerical expression specifying the length, in characters, of the part to be taken.

Example

MidStr("Largest winning trade", 1, 7);

Will return a string expression "Largest".

Notes

• See LeftStr to return the leftmost part of a string,
• See RightStr to return the rightmost part of a string,
• See InStr to get the starting location of a expression in a string.