Lists

Methods

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 a 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.
  • ListRemoveDuplicates Removes duplicate values from list.
  • ListRest Gets a list, without its first element.
  • ListSetAt Replaces the contents of a list element.
  • 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.
  • 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.