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.1   9.2   9.3   9.4   9.5   10.0   10.1   10.2   10.3   10.4    Statistic  


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

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


Parameter Description Example value
List1 The reference to the first quicklist. $List1
List2 The reference to the second quicklist. $List2
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.
ReturnNewList Optional
Pass 1 to return result as new QuickList. This new list must be freed later using QuickList.Free function. Pass 0 (Default) to modify the list in the List1 parameter.


Returns list, OK or error.


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

Checks the given column in both lists too compare.
If Separator is empty, this is same as QuickList.And, but slower.

See also

Blog Entries

Release notes

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

QuickList.And   -   QuickList.BestMatch

Feedback: Report problem or ask question.

MBS Xojo Chart Plugins