Topics   All   MacOS (Only)   Windows (Only)   Linux (Only, Not)   iOS (Only, Not)  
Components   Crossplatform Mac & Win   Server   Client   Old   Deprecated   Guides   Examples   Videos
New in version: 9.3   9.4   9.5   10.0   10.1   10.2   10.3   10.4   10.5   10.6    Statistic    FMM    Blog  

List.Not

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

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 OK or error.

Description

Examples

Operate not on two lists:

MBS("List.Not"; "Abc¶Def¶Ghi¶Jkl"; "Abc¶Jkl¶Zui¶Edf" )

See also

• List.NotColumn
• List.Sort
• QuickList.NotColumn

Blog Entries

• MBS Filemaker Plugin, version 4.4pr5

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.

Created 8th October 2014, last changed 8th October 2014

List.MatchesPrefix   -   List.NotColumn

Feedback: Report problem or ask question.