Lists

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() remove empty items at the and and at the start 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 array. the function returns an array that contains all values returned by the closure.
  • string.listPrepend() Inserts an element at the beginning of a list.
  • string.listQualify() Inserts a string at the beginning and end of list elements.
  • string.listReduce() Iterates over every entry of the given array and calls the closure with every element. This function will reduce the array 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.

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() remove empty items at the and and at the start 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 array. the function returns an array that contains all values returned by the closure.
  • ListPrepend() Inserts an element at the beginning of a list.
  • ListQualify() Inserts a string at the beginning and end of list elements.
  • ListReduce() Iterates over every entry of the given array and calls the closure with every element. This function will reduce the array 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.