Components All New MacOS Windows Linux iOS
Examples Mac & Win Server Client Guides Statistic FMM Blog Deprecated Old

List.FindEquals

Finds equal items in both lists.

Component Version macOS Windows Linux Server iOS SDK
List 4.2 ✅ Yes ✅ Yes ✅ Yes ✅ Yes ✅ Yes
MBS( "List.FindEquals"; 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 new list.

Description

Finds equal items in both lists.
Same as List.And function.

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

Find equal entries in both lists:

MBS( "List.FindEquals"; "Hello" ¶ "World"; "Hello" ¶ "Friends" )

See also

Example Databases

Blog Entries

Created 18th August 2014, last changed 20th December 2023


List.FindDuplicateItems - List.FindUnequals