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 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 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

Release notes

Example Databases

Blog Entries

This function checks for a license.

Created 18th August 2014, last changed 10th December 2023


List.Remove - List.RemoveEmptyItems