Brian Dunning's FileMaker Custom Functions

IdentifyDupes ( Original_List, i, Dupes )

Returns only unique duplicate values from a list. Most of the time we're trying to identify the unique values in a list. This CF returns the values in a list that have duplicates.

  Average rating: 4.7 (29 votes) Log in to vote

Jon Rosen   Jon Rosen
ErgoSoma
http://www.ergosoma.com

Share on Facebook Share on Twitter

  Sample input:
IdentifyDupes ( Apples
Apples
Bananas
Cherries
Grapes
Grapes
Grapes ; 1 ; "" )
  Sample output:
Apples
Grapes

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

Usually, we're trying to identify the unique values in a list. This custom function does the reverse. It returns a unique list of duplicate values from a list (one value per duplicate).

 

Comments

caps   caps, Portugal
Feb 25, 2012
This function have some issues, because when you try to past it into custom function, there are warnings about some variables that aren't identified.

Developer,
1. How is possible to have "1" or empty "" as function parameter?
2. The function parameter is List_of_Values, but you use a variable called Original_List.

Thanks,
 
caps   caps, Portugal
Feb 25, 2012
Hi found the problem, the tittle is wrong should be:

IdentifyDupes ( Original_List ; i ; Dupes )
 
Jon Rosen   Jon Rosen, Florida
Feb 25, 2012
Thanks for pointing that out. I changed the title.
 
H   H, CHCH
Mar 8, 2016
Thanks for sharing!
 

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.