| Components | All | New | MacOS | Windows | Linux | iOS | ||||
| Examples | Mac & Win | Server | Client | Guides | Statistic | FMM | Blog | Deprecated | Old | |
List.Not
Returns values of first list which are not in second list.
| Component | Version | macOS | Windows | Linux | Server | iOS SDK |
| List | 4.4 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes |
MBS( "List.Not"; List1; List2 { ; NoReturnEnding } ) More
Parameters
| Parameter | Description | Example | Flags |
|---|---|---|---|
| List1 | The first list. | "Hello" ¶ "World" | |
| List2 | The second list. | "Hello" ¶ "Friends" | |
| NoReturnEnding | Pass 1 to have no extra newline character on the end of the returned list. Default is 0 to include one to easily concat lists. | 1 | Optional |
Result
Returns list or error.
Description
Returns values of first list which are not in second list.Performs a logical NOT operation.
Examples
Operate not on two lists:
MBS("List.Not"; "Abc¶Def¶Ghi¶Jkl"; "Abc¶Jkl¶Zui¶Edf" )
See also
Release notes
- Version 10.0
- Added List.AndColumn, List.NotColumn, List.OrColumn, and List.XOrColumn functions.
- Added QuickList.AndColumn, QuickList.NotColumn, QuickList.OrColumn, and QuickList.XOrColumn functions.
Blog Entries
This function checks for a license.
Created 8th October 2014, last changed 9th November 2021
