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