Lists

Functions

• ArrayToList() Transform the array to a list of elements delimiter by the given string
• ListAppend() Concatenates a list or element to a list.
• ListAvg()
• ListChangeDelims() Changes a list delimiter. Returns a copy of the list, with each delimiter character replaced by new_delimiter.
• ListCompact() Removes any empty items from the start and end of the list
• ListContains() Determines the index of the first list element that contains a specified substring. Returns the index of the first list element that contains substring. If not found, returns zero.
• ListContainsNoCase() Determines the index of the first list element that contains a specified substring.
• ListDeleteAt() Deletes an element from a list. Returns a copy of the list, without the specified element.
• ListEach() call the given UDF/Closure with every value in the string list.
• ListEvery() This function calls a given closure/function with every element in a given string list and returns true, if all of the closure calls returns true.
• ListFilter() This function creates a new string list that returns all entries from an string list that match the given filter.
• ListFind() Determines the index of the first list element in which a specified value occurs. Case-sensitive
• ListFindNoCase() Determines the index of the first list element in which a specified value occurs
• ListFirst() Gets the first element of a list.
• ListGetAt() Gets a list element at a specified position.
• ListIndexExists() Determines if an element at the given position exists or not
• ListInsertAt() Inserts an element in a list.
• ListItemTrim() Removes all the white space surrounding each element, returning back the new list
• ListLast() Gets the last element of a list.
• ListLen() Determines the number of elements in a list.
• ListMap() Calls the given closure with every element in the given list. The function returns a list that contains all values returned by the closure.
• ListPrepend() Inserts an element at the beginning of a list.
• ListQualifiedToArray() Copies the elements of a list to an array.
• ListQualify() Inserts a string at the beginning and end of list elements.
• ListReduce() Iterates over every entry of the given list and calls the closure with every element. This function will reduce the list to a single value and will return the value.
• ListRemoveDuplicates() Removes duplicate values from list.
• ListRest() Gets a list, without its first element.
• ListSetAt() Replaces the contents of a list element.
• ListSome() This function calls a given closure/function with every element in a given string list and returns true, if one of the closure calls returns true.
• ListSort() Sorts list elements according to a sort type and sort order.
• ListToArray() Copies the elements of a list to an array.
• ListTrim() this function is deprecated, use instead ListCompact
• ListValueCount() Counts instances of a specified value in a list. The search is case-sensitive.
• ListValueCountNoCase() Counts instances of a specified value in a list. The search is case-insensitive.
• ReplaceList() Replaces occurrences of the elements from a delimited list in a string with corresponding elements from another delimited list. The search is case-sensitive.
• ReplaceListNoCase() Replaces occurrences of the elements from a delimited list in a string with corresponding elements from another delimited list. The search is NOT case-sensitive.

Methods

• array.toList() Transform the array to a list of elements delimiter by the given string
• string.listAppend() Concatenates a list or element to a list.
• string.listAvg()
• string.listChangeDelims() Changes a list delimiter. Returns a copy of the list, with each delimiter character replaced by new_delimiter.
• string.listCompact() Removes any empty items from the start and end of the list
• string.listContains() Determines the index of the first list element that contains a specified substring. Returns the index of the first list element that contains substring. If not found, returns zero.
• string.listContainsNoCase() Determines the index of the first list element that contains a specified substring.
• string.listDeleteAt() Deletes an element from a list. Returns a copy of the list, without the specified element.
• string.listEach() call the given UDF/Closure with every value in the string list.
• string.listEvery() This function calls a given closure/function with every element in a given string list and returns true, if all of the closure calls returns true.
• string.listFilter() This function creates a new string list that returns all entries from an string list that match the given filter.
• string.listFind() Determines the index of the first list element in which a specified value occurs. Case-sensitive
• string.listFindNoCase() Determines the index of the first list element in which a specified value occurs
• string.listFirst() Gets the first element of a list.
• string.listGetAt() Gets a list element at a specified position.
• string.listIndexExists() Determines if an element at the given position exists or not
• string.listInsertAt() Inserts an element in a list.
• string.listItemTrim() Removes all the white space surrounding each element, returning back the new list
• string.listLast() Gets the last element of a list.
• string.ListLen() Determines the number of elements in a list.
• string.listMap() Calls the given closure with every element in the given list. The function returns a list that contains all values returned by the closure.
• string.listPrepend() Inserts an element at the beginning of a list.
• string.listQualifiedToArray() Copies the elements of a list to an array.
• string.listQualify() Inserts a string at the beginning and end of list elements.
• string.listReduce() Iterates over every entry of the given list and calls the closure with every element. This function will reduce the list to a single value and will return the value.
• string.listRemoveDuplicates() Removes duplicate values from list.
• string.listRest() Gets a list, without its first element.
• string.listSetAt() Replaces the contents of a list element.
• string.listSome() This function calls a given closure/function with every element in a given string list and returns true, if one of the closure calls returns true.
• string.listSort() Sorts list elements according to a sort type and sort order.
• string.listToArray() Copies the elements of a list to an array.
• string.listValueCount() Counts instances of a specified value in a list. The search is case-sensitive.
• string.listValueCountNoCase() Counts instances of a specified value in a list. The search is case-insensitive.
• string.replaceList() Replaces occurrences of the elements from a delimited list in a string with corresponding elements from another delimited list. The search is case-sensitive.
• string.replaceListNoCase() Replaces occurrences of the elements from a delimited list in a string with corresponding elements from another delimited list. The search is NOT case-sensitive.