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()

  Calculates average from all numeric values given in the list

• 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.

• ListGetDuplicates()

  Gets a list of duplicate values from a list.

• 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()

  Calculates average from all numeric values given in the list

• 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.listGetDuplicates()

  Gets a list of duplicate values from a list.

• 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.