Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

excluded(arrayA, arrayB)

ArgumentTypeDescription
setAarrayAArrayAn Array of values of any type.
setBarrayBArrayAn Array of values of any type.

Returns an Array of all items that are in setA arrayA that are not in setB arrayB.

Examples

excluded(["a","b","c","d","e"],["a", "c","f","d"])

...

listToString(excluded(["a","b","c","d","e"],["a","a","c","f","d"]))


If an excluded element appears more than once in the first array (array A), then it will appear the same number of times in the array returned:

excluded(["a","b","c","d","e","e"],["a", "c","f","d"])

returns ["b","e","e"].

To be clear, if an element in the first array (array A) exists at all in the comparator array (array B), then it will not count as excluded:

excluded(["a","b","c","d","e","e"],["a", "c","f","d","e"])

returnsĀ ["b"].


Note that if you want to construct conditional expression using excluded() as a predicate, you should use an intermediary countElements() function:

...