QuickList.NotColumn
-------------------

Returns values of first list which are not in second list.

| Component | Version | macOS | Windows | Linux | Server | iOS SDK |
|---|---|---|---|---|---|---|
| [List](component_List.md) | [10.0](newinversion100.md) | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes |

MBS( "QuickList.NotColumn"; List1; List2; Separator; Column { ; ReturnNewList } ) 

**MBS**( **"QuickList.NotColumn";** /\* Returns values of first list which are not in second list. \*/  
**$List1**; /\* The reference to the first quicklist. \*/   
**$List2**; /\* The reference to the second quicklist. \*/   
**$Separator**; /\* The separator text.  
Can be multiple characters.  
For tab separated text, pass Char(9). For CSV separated text, pass ";" or ",".e.g. Char(9) \*/   
**$Column**; /\* The index of the column to compare.  
Starts with 0 for first column.e.g. 0 \*/   
**$ReturnNewList**) /\* Optional; Pass 1 to return result as new QuickList.   
This new list must be freed later using [QuickList.Release](QuickListRelease.md) function. Pass 0 (Default) to modify the list in the List1 parameter.e.g. 0 \*/ 

### Parameters

| Parameter | Description | Example | Flags |
|---|---|---|---|
| List1 | The reference to the first quicklist. | $List1 |  |
| List2 | The reference to the second quicklist. | $List2 |  |
| Separator | The separator text.   Can be multiple characters.   For tab separated text, pass Char(9). For CSV separated text, pass ";" or ",". | Char(9) |  |
| Column | The index of the column to compare.   Starts with 0 for first column. | 0 |  |
| ReturnNewList | Pass 1 to return result as new QuickList.    This new list must be freed later using [QuickList.Release](QuickListRelease.md) function. Pass 0 (Default) to modify the list in the List1 parameter. | 0 | Optional |

### Result

Returns list, OK or error.

### Description

Returns values of first list which are not in second list.  
Performs a logical NOT operation.  
  
Checks the given column in both lists too compare.  
If Separator is empty, this is same as [QuickList.Not](QuickListNot.md), but slower.  
### See also

- [List.Not](ListNot.md)
- [QuickList.AndColumn](QuickListAndColumn.md)
- [QuickList.DeleteColumn](QuickListDeleteColumn.md)
- [QuickList.GetColumn](QuickListGetColumn.md)
- [QuickList.Not](QuickListNot.md)
- [QuickList.OrColumn](QuickListOrColumn.md)
- [QuickList.Release](QuickListRelease.md)
- [QuickList.XOrColumn](QuickListXOrColumn.md)

### Release notes

- **Version 10.0**
    - Added [QuickList.AndColumn](https://www.mbsplugins.eu/QuickListAndColumn.shtml), [QuickList.NotColumn](https://www.mbsplugins.eu/QuickListNotColumn.shtml), [QuickList.OrColumn](https://www.mbsplugins.eu/QuickListOrColumn.shtml), and [QuickList.XOrColumn](https://www.mbsplugins.eu/QuickListXOrColumn.shtml) functions.

### Blog Entries

- [MBS FileMaker Plugin, version 10.0pr5](https://www.mbsplugins.de/archive/2020-01-02/MBS_FileMaker_Plugin_version_1/monkeybreadsoftware_blog_filemaker)

This function checks for a license.

Created 23th December 2019 , last changed 14th December 2023

  
[QuickList.Not](QuickListNot.md) - [QuickList.Or](QuickListOr.md)

[HTML Version](QuickListNotColumn.shtml)