Function | Description |
@Compare | Compares two lists pair-wise. |
@Count(list) | Determines the number of elements in a list, returning 1 if the value it is evaluating is a null string or not a list. |
@Elements(list) | Determines the number of elements in a list, returning 0 if the value it is evaluating is a null string or not a list. |
@Explode(string) | Converts a text string into a text list. Spaces, commas, semicolons, and newlines separate elements in the string. |
@Explode(string ; separators) | Converts a text string into a text list; the second parameter specifies the separators (except newlines) for elements in the string. |
@Explode(string ; separators ; includeEmpties) | Converts a text string into a text list; @True as the third parameter includes empty list elements where consecutive separators occur. |
@Explode(string ; separators ; includeEmpties ; newlineAsSeparator) | Converts a text string into a text list; @False as the fourth parameter excludes newlines as separators. |
@Explode(dateRange) | Converts a date range into a list of dates. The argument must be a time-date value; the return value is a text list. |
@Implode(list) | Converts a text list to a text string, using spaces to separate elements. |
@Implode(list ; separator) | As above, but the second parameter specifies the separator for elements in the string. |
@IsMember(string ; list) | Determines if a string is a member of a list. Returns True (1) or False (0). |
@IsMember(list1; list2) | Determines if a list is contained in another list. Returns True (1) or False (0). |
@IsNotMember(string ; list) | Determines if a string is not a member of a list. Returns True (1) or False (0). |
@IsNotMember(list1; list2) | Determines if a list is not contained in another list. Returns True (1) or False (0). |
@Keywords(list1; list2) | Locates words in list1 that match words in list2. Word separators are " , ? ! ; : [ ] { } < > |
@Keywords(list1; list2; separator) | As above, but the second parameter specifies the word separators. |
@Max (number or numberlist) | Returns the largest number in the list. |
@Max (number or numberlist ; number or numberlist) | Returns the larger number of two numbers or a number list of the largest numbers resulting from a pair-wise computation of two number lists. |
@Member(value ; list) | Determines the position of a value in a string list. |
@Min (number or numberlist) | Returns the smallest number in the list. |
@Min (number or numberlist ; number or numberlist) | Returns the smaller number of two numbers or a number list of the smallest numbers resulting from a pair-wise computation of two number lists. |
@Nothing | Adds nothing to a transformed list. |
@Replace(list1; list2; list3) | Replaces values in list1 that match values in list2 with the corresponding values in list3. |
@Sort( list ; [order] ) | Sorts a list. Order is [Ascending] (default) or [Descending]. |
@Subset(list ; n) | Extracts n number of values from the list. Use -n to extract right to left. |
@Transform(list ; name ; formula) | Applies a formula to each element of a list. |
@Unique(list) | Removes duplicate values from a string list. |
@Unique | Returns a random, unique text value. |