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
- List.Find
- List.HasDuplicateItems
- List.Remove
- List.RemoveDuplicateItems
- QuickList.Find
- QuickList.FindDuplicateItems
Release notes
- Version 14.0
- Added CaseSensitive flag for List.FindDuplicateItems, List.HasDuplicateItems, List.RemoveDuplicateItems, QuickList.FindDuplicateItems, QuickList.HasDuplicateItems, QuickList.RemoveDuplicateItems.
- Version 10.5
- Added List.FindDuplicateItems and QuickList.FindDuplicateItems functions.
Blog Entries
- MBS FileMaker Plugin, version 13.6pr3
- New in MBS FileMaker Plugin 10.5
- MBS FileMaker Plugin, version 10.5pr1
FileMaker Magazin
This function checks for a license.
Created 28th September 2020, last changed 10th December 2023