List.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( "List.NotColumn"; List1; List2; Separator; Column { ; NoReturnEnding } ) 

**MBS**( **"List.NotColumn";** /\* Returns values of first list which are not in second list. \*/  
**$List1**; /\* The first list.e.g. "Hello" ¶ "World" \*/   
**$List2**; /\* The second list.e.g. "Hello" ¶ "Friends" \*/   
**$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 \*/   
**$NoReturnEnding**) /\* Optional; 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.e.g. 1 \*/ 

### Parameters

| Parameter | Description | Example | Flags |
|---|---|---|---|
| List1 | The first list. | "Hello" ¶ "World" |  |
| List2 | The second list. | "Hello" ¶ "Friends" |  |
| 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 |  |
| 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.  
  
Checks the given column in both lists too compare.  
If Separator is empty, this is same as [List.Not](ListNot.md), but slower.  
### See also

- [List.AndColumn](ListAndColumn.md)
- [List.GetColumn](ListGetColumn.md)
- [List.Not](ListNot.md)
- [List.OrColumn](ListOrColumn.md)
- [List.XOrColumn](ListXOrColumn.md)

### Release notes

- **Version 10.0**
    - Added [List.AndColumn](https://www.mbsplugins.eu/ListAndColumn.shtml), [List.NotColumn](https://www.mbsplugins.eu/ListNotColumn.shtml), [List.OrColumn](https://www.mbsplugins.eu/ListOrColumn.shtml), and [List.XOrColumn](https://www.mbsplugins.eu/ListXOrColumn.shtml) functions.
    - 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

- [New in the MBS FileMaker Plugin 10.0](https://www.mbsplugins.de/archive/2020-01-23/New_in_the_MBS_FileMaker_Plugi/monkeybreadsoftware_blog_filemaker)
- [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 23th December 2019

  
[List.Not](ListNot.md) - [List.Or](ListOr.md)

[HTML Version](ListNotColumn.shtml)