Topics   All   Mac OS X (Only)   Windows (Only)   Linux (Only, Not)   iOS (Only, Not)  
Components   Crossplatform Mac & Win   Server   Client   Old   Guides   Examples
New in version: 7.4   7.5   8.0   8.1   8.2   8.3   8.4   8.5   9.0   9.1    Statistic  


Removes duplicate items in the list.

Component Version macOS Windows Server FileMaker Cloud FileMaker iOS SDK
List 4.2 Yes Yes Yes Yes Yes
MBS( "List.RemoveDuplicateItems"; List { ; NoReturnEnding; RemoveAll } )   More


Parameter Description Example value
List The list to process. "Hello" ¶ "Hello" ¶ "World"
NoReturnEnding Optional
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.
RemoveAll Optional
If duplicate is found also remove the first occurrence. Set to 1 to enable or 0 to disable. Default is disabled.


Returns new list.


Removes duplicate items in the list.
Similar to UniqueValues function in FileMaker to find unique values.


Remove duplicates:

MBS( "List.RemoveDuplicateItems"; "Hello¶World¶Hello" )

Remove all duplicates

MBS( "List.RemoveDuplicateItems"; "Hello¶World¶Hello"; 0; 1 )

See also

Example Databases

Blog Entries

Created 18th August 2014, last changed 6th February 2018

List.Remove   -   List.RemoveEmptyItems

Feedback: Report problem or ask question.

MBS FileMaker Plugins