Middle

Kalipso - Form - Expressions - Functions - Functions Descriptions - String Functions - Middle

This Function returns a <string>, which is a substring of the specified Source string, starting at the Starting position, with the specified Length.

Parameters

• Source string <string> - String from where to extract a substring.

• Starting position <string> - Starting position in the Source string of the string to extract.

• Length <numeric> - Length of the substring to extract.

Examples

• Example 1

Mid("Enjoy Kalipso.", 7, 7) Result = Kalipso

• Example 2

Mid("Enjoy Kalipso.", 0, 5) Result = Enjoy

• Example 3

Mid("Enjoy Kalipso.", 15, 2) Result =

• Example 4

Mid("Enjoy Kalipso.", 7, 10) Result = Kalipso.

If you specify a Starting position higher than the length of the specified Source string, and empty string will be returned.

If you specify a Length higher than the difference between the length of the specified Source string and the specified Starting position, the returned string will be the left part of the Source string, starting at Starting position.