FORMULA LANGUAGE


@Middle
Example

Returns any substring from the middle of a string. The middle is found by scanning the string from left to right, and parameters determine where the middle begins and ends.

Syntax

@Middle( string ; offset ; numberchars )
@Middle(
string ; offset ; endstring )
@Middle(
string ; startString ; endstring )
@Middle(
string ; startString ; numberchars )

Parameters

string


offset
startString
numberchars
endstring
Return value

middle


Usage

If the first parameter is a list, the function operates on each element of the list, and the return value is a list with the same number of elements.

Language cross-reference

Mid function of LotusScript language

Example
See Also