Brian Dunning's FileMaker Custom Functions

ListOfUniq ( listOfValues )

Delete duplicate values from a list.

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

HAZI   HAZI
none
http://hazisarashi.com/

Share on Facebook Share on Twitter

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

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

none

 

Comments

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 BrianDunning.com. Please contact the individual developer with any questions or problems.

Under construction. Email me your wish list for improvements.