| Components | All | New | MacOS | Windows | Linux | iOS | ||||
| Examples | Mac & Win | Server | Client | Guides | Statistic | FMM | Blog | Deprecated | Old | |
List.HasDuplicateItems
Checks if list has duplicates.
| Component | Version | macOS | Windows | Linux | Server | iOS SDK |
| List | 7.5 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes |
MBS( "List.HasDuplicateItems"; List { ; CaseInsensitive } ) More
Parameters
| Parameter | Description | Example | Flags |
|---|---|---|---|
| List | The list to process. | "Hello" ¶ "Hello" ¶ "World" | |
| 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 1, 0 or error.
Description
Checks if list has duplicates.Returns 1 if duplicate lines are found or 0 if not.
Examples
Try it:
MBS( "List.HasDuplicateItems"; "Hello¶Test¶World¶Test" )
Example result: 1
Try with case sensitive and case insenstive:
MBS( "List.HasDuplicateItems"; "a¶A"; 0) & MBS( "List.HasDuplicateItems"; "a¶A"; 1)
Example result: 01
See also
Release notes
- Version 14.0
- Added CaseSensitive flag for List.FindDuplicateItems, List.HasDuplicateItems, List.RemoveDuplicateItems, QuickList.FindDuplicateItems, QuickList.HasDuplicateItems, QuickList.RemoveDuplicateItems.
- Version 7.5
Blog Entries
This function checks for a license.
Created 21st October 2017, last changed 10th December 2023
