Brian Dunning's FileMaker Custom Functions

ListOfUniq ( listOfValues )

Delete duplicate values from a list.

  Average rating: 4.6 (32 votes) Log in to vote


Share on Facebook Share on Twitter

  Sample input:
RectangleArea ( "AAA¶BBB¶CCC¶AAA¶DDD" )
  Sample output:

  Function definition: (Copy & paste into FileMaker's Edit Custom Function window)




Bruce Robertson   Bruce Robertson
Dec 6, 2011
Doesn't work as posted; error in the parameter name inside the calc.

Shouldn't Data be ListOfValues

Data <> "__NULL__" ;
Let ([
// Initialize
$$_ListOfUniq_Data = Data
Bruce Robertson   Bruce Robertson
Dec 6, 2011
When corrected, it appears to be noticeably slower than XORValues(ListA; ListB), which does the same thing when ListA or ListB is empty.

Log in to post comments.


Note: these functions are not guaranteed or supported by Please contact the individual developer with any questions or problems.

Under construction. Email me your wish list for improvements.