Monkeybread Software - MBS FileMaker Plugin: List.RemoveDuplicateItems

Topics All MacOS (Only) Windows (Only) Linux (Only, Not) iOS (Only, Not)
Components Crossplatform Mac & Win Server Client Old Deprecated Guides Examples Videos
New in version: 9.3 9.4 9.5 10.0 10.1 10.2 10.3 10.4 10.5 10.6 Statistic FMM Blog

List.RemoveDuplicateItems

Removes duplicate items in the list.

Component	Version	macOS	Windows	Linux	Server	FileMaker iOS SDK
List	4.2	Yes	Yes	Yes	Yes	Yes

MBS( "List.RemoveDuplicateItems"; List { ; NoReturnEnding; RemoveAll } ) 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

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

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 )

Example Databases

Text functions/Lists

Blog Entries

Release notes

Version 10.4
- Added RemoveAll and ReturnNewList parameters to QuickList.RemoveDuplicateItems function.

Created 18th August 2014, last changed 8th August 2020

List.Remove - List.RemoveEmptyItems

Feedback: Report problem or ask question.