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

List.FindDuplicateItems

Finds duplicate items in the list.

Component Version macOS Windows Linux Server iOS SDK
List 10.5 ✅ Yes ✅ Yes ✅ Yes ✅ Yes ✅ Yes
MBS( "List.FindDuplicateItems"; List { ; NoReturnEnding; CaseInsensitive } )   More

Parameters

Parameter Description Example Flags
List The list to process. "Hello" ¶ "Hello" ¶ "World"
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
CaseInsensitive Available in MBS FileMaker Plugin 14.0 or newer.
Whether to perform comparison case insensitve.
By default we do case sensitive operations, which are faster.
Pass 1 for insensitve or 0 for sensitive.
0 Optional

Result

Returns list or error.

Description

Finds duplicate items in the list.
Returns list with all duplicate items, but only counts each one once.
Similar to List.RemoveDuplicateItems and see also QuickList.FindDuplicateItems.

Examples

Find duplicates

MBS( "List.FindDuplicateItems"; "1¶2¶3¶4¶1¶7¶7¶8¶1")

Example result:
1
7

Find duplicates case insensitive:

MBS( "List.FindDuplicateItems"; "a¶A¶b¶c¶C"; 0; 1)

Example result:
a
b
c

See also

Release notes

Blog Entries

This function checks for a license.

Created 28th September 2020, last changed 10th December 2023


List.Find - List.FindEquals