Investment Studio > Expressions > Functions > Text > MID

string mid(string in_string, integer start, integer length)

Returns length characters of in_string from the start position.

The start position must be >= 1. If it exceeds the length of in_string, "" (i.e. an empty string) is returned.

The specified length must be >= 0; if start + length exceeds the length of in_string, all characters from the start position up to the end of in_string are returned.

Examples

=mid("Asset Flow", 1, 5)

equals "Asset"

=mid("Asset Flow", 7, 30)

equals "Flow"

=mid("ABCD", 5, 5)

equals "" (empty string).

See also left, len, right.