This function performs numeric operations on a list or calculates numeric values based on the length of a list item. Where a numeric list element is assumed, the list item must start with a numeric value. If it does not zero will be assumed. Note that negative numbers and numbers with fractions are supported.
The function essentially has three operating modes:
- Source in track variable, result to track variable
- Each file is processed as a separate entity. Each source track variable contains a list and each destination track variable receives a result. List elements are separated by a specified delimiter.
- Source in named variable, result to named variable
- The source named variable contains the list and the destination named variable receives the result. List elements are separated by a specified delimiter.
- Source in track variable, result to named variable
- Each track variable is treated as being a single list item. The destination named variable receives the result. There is no delimiter as each source track variable is a list item.
Text fields may contain any of the escape sequences described in Escape Sequences. Note when running stepwise escape sequences are evaluated only once based on the first file's field values.
The following functions are supported:
- Sum
- Returns the sum of the list elements. Numeric list items are expected.
- Average
- Returns the average of the list elements. Numeric list items are expected.
- Minimum Value
- Returns the minimum value. Numeric list items are expected.
- Maximum Value
- Returns the maximum value. Numeric list items are expected.
- Index of Minimum Value
- Returns the list index containing the first occurrence of the minimum value. Numeric list items are expected.
- Index of Maximum Value
- Returns the list index containing the first occurrence of the maximum value. Numeric list items are expected.
- Minimum Length
- Returns the minimum length of all list items.
- Maximum Length
- Returns the maximum length of all list items.
- Index of Minimum Length
- Returns the list index of the first occurrence of an item which has the minimum length.
- Index of Maximum Length
- Returns the list index of the first occurrence of an item which has the maximum length.
- Unicode String
- Returns a string representing the Unicode character values in the list. Empty and invalid list elements are ignored. Note that ␦ will be returned for characters which do not have a displayable representation.
The index functions are invalid when the source is in track variables and the destination is in a named variable. If a list is empty all of functions except Unicode String return 0.
When appropriate, you can specify a post operation to limit the result to an integer value. The possibilities are None (fractional results may be returned), Round, Truncate, Floor and Ceiling.
