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: 10.1   10.2   10.3   10.4   10.5   11.0   11.1   11.2   11.3   11.4    Statistic    FMM    Blog  


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

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


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


Returns list or error.


Returns a list with values which are contained in both lists.
Performs a logical AND operation.

Returns a list with values from list2 where the columns compared are contained in both lists.
Checks the given column in both lists too compare.
If Separator is empty, this is same as List.And, but slower.


AND two lists based on 2 column:

MBS( "List.AndColumn";
"1 test 3¶a b c¶d¶e f";
"2 test 4¶a f c¶d b";
" "; 1 )

Example result:
2 test 4
a f c
d b

See also

Release notes

Blog Entries

Created 23th December 2019, last changed 1st February 2021

List.And - List.BestMatch

Feedback: Report problem or ask question.

MBS FileMaker Plugins

Start Chat