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

List.FindUnequals

Finds unequal items in both lists.

Component Version macOS Windows Linux Server iOS SDK
List 4.2 ✅ Yes ✅ Yes ✅ Yes ✅ Yes ✅ Yes
MBS( "List.FindUnequals"; List1; List2 { ; NoReturnEnding; NotFromSecondList } )   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
NotFromSecondList Pass 1 to only returns items from first list not present in second list.
Default is 0 to get items from both lists.
0 Optional

Result

Returns new list.

Description

Finds unequal items in both lists.

Examples

Find non equal entries in both lists:

MBS( "List.FindUnequals"; "Hello¶World"; "Hello¶Friends"; 1 )

Example result:
"World
Friends"

Find items in first list which are not in second list:

MBS( "List.FindUnequals"; "Hello¶World"; "Hello¶Friends"; 1; 1 )

Example result: "World"

See also

Release notes

Example Databases

Blog Entries

Created 18th August 2014, last changed 11st August 2021


List.FindEquals - List.GetColumn