MaxList

Description

Returns the maximum item from the specified list, ignoring blank items. Returns a blank string if the list contains an item not of the specified type.

Syntax

MaxList(InputList: String,Delimiter: String,ItemType: String)

InputList specifies the list to use.

Delimiter is the character to use to delineate items in the string list. Supported special characters:

Note:

You must use the name of the delimiter (not the character) and include brackets around the name.

ItemType indicates the expected item data type for list members. Valid values: integer, float, and datetime. The default value is float.

Example

MaxList(1;2;3,[comma],Integer)

Return value is 3.