Topics   All   Mac OS X (Only)   Windows (Only)   Linux (Only, Not)   iOS (Only, Not)  
Components   Crossplatform Mac & Win   Server   Client   Old   Guides   Examples
New in version: 8.5   9.0   9.1   9.2   9.3   9.4   9.5   10.0   10.1   10.2    Statistic  


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

Component Version macOS Windows Server FileMaker Cloud FileMaker iOS SDK
List 10.0 Yes Yes Yes Yes Yes
MBS( "List.NotColumn"; List1; List2; Separator; Column { ; NoReturnEnding } )   More


Parameter Description Example value
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 ",".
Column The index of the column to compare.
Starts with 0 for first column.
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.


Returns list or error.


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, but slower.

See also

Blog Entries

Release notes

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

List.Not   -   List.Or

Feedback: Report problem or ask question.

MBS FileMaker Plugins