| Components | All | New | MacOS | Windows | Linux | iOS | ||||
| Examples | Mac & Win | Server | Client | Guides | Statistic | FMM | Blog | Deprecated | Old | |
List.RemoveDuplicateItems
Removes duplicate items in the list.
| Component | Version | macOS | Windows | Linux | Server | iOS SDK |
| List | 4.2 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes |
MBS( "List.RemoveDuplicateItems"; List { ; NoReturnEnding; RemoveAll; 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 |
| RemoveAll | If duplicate is found also remove the first occurrence. Set to 1 to enable or 0 to disable. Default is disabled. | 1 | Optional |
| CaseInsensitive | 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 Added in version 14.0. |
Result
Returns new list.
Description
Removes duplicate items in the list.Similar to UniqueValues function in FileMaker to find unique values.
See also QuickList.RemoveDuplicateItems function.
Examples
Remove duplicates:
MBS( "List.RemoveDuplicateItems"; "Hello¶World¶Hello" )
Remove all duplicates
MBS( "List.RemoveDuplicateItems"; "Hello¶World¶Hello"; 0; 1 )
See also
- List.FindDuplicateItems
- List.HasDuplicateItems
- List.Remove
- QuickList.FindDuplicateItems
- QuickList.Remove
- QuickList.RemoveDuplicateItems
Release notes
- Version 14.0
- Added CaseSensitive flag for List.FindDuplicateItems, List.HasDuplicateItems, List.RemoveDuplicateItems, QuickList.FindDuplicateItems, QuickList.HasDuplicateItems, QuickList.RemoveDuplicateItems.
- Version 10.4
- Added RemoveAll and ReturnNewList parameters to QuickList.RemoveDuplicateItems function.
Example Databases
Blog Entries
This function checks for a license.
Created 18th August 2014, last changed 10th December 2023
