Components | All | New | MacOS | Windows | Linux | iOS | ||||
Examples | Mac & Win | Server | Client | Guides | Statistic | FMM | Blog | Deprecated | Old |
List.And
Returns a list with values which are contained in both lists.
Component | Version | macOS | Windows | Linux | Server | iOS SDK |
List | 4.4 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes |
MBS( "List.And"; List1; List2 { ; NoReturnEnding } ) More
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
Returns a list with values which are contained in both lists.Performs a logical AND operation.
This function is made for lists without duplicate values as it checks if values from one list exists in others, which may not work correctly if one list has duplicate values.
Examples
Perform logical AND on list:
MBS( "List.AND"; "1¶2¶3¶4"; "3¶4¶5¶6" )
See also
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
- New in MBS FileMaker Plugin in Version 14.5
- Combined Components with MBS FileMaker Plugin
- MBS Filemaker Plugin, version 4.4pr3
FileMaker Magazin
This function checks for a license.
Created 25th September 2014, last changed 20th December 2023