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.5   10.0   10.1   10.2   10.3   10.4   10.5   11.0   11.1   11.2    Statistic    FMM    Blog  

List.And

Returns a list with values which are contained in both lists.

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

Examples

Perform logical AND on list:

MBS( "List.And"; "1¶2¶3¶4"; "3¶4¶5¶6" )

See also

• List.AndColumn
• List.Find
• QuickList.And
• QuickList.AndColumn

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

• Combined Components with MBS FileMaker Plugin
• MBS Filemaker Plugin, version 4.4pr3

FileMaker Magazin

• Ausgabe 2/2020, Seite 35

Created 25th September 2014, last changed 25th September 2014

List.AddValue   -   List.AndColumn

Feedback: Report problem or ask question.