Topics   All   Mac OS X (Only)   Windows (Only)   Linux (Only, Not)   iOS (Only, Not)  
Components   Crossplatform Mac & Win   Server   Client   Old   Guides   Examples
New in version: 8.3   8.4   8.5   9.0   9.1   9.2   9.3   9.4   9.5   10.0    Statistic  

QuickList.AndColumn

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

Parameters

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

Result

Returns list, OK or error.

Description

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

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


QuickList.And   -   QuickList.BestMatch

Feedback: Report problem or ask question.




Links
MBS Xojo Plugins