DupesInList ( ValueList )

Returns duplicate values from a list.

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

Daniele Raybaudi - Show more from this author
ACI
http://www.aci.it

Sample input:

DupesInList ( "a¶b¶a¶c¶a" )

Sample output:

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

/*
DupesInList ( ValueList ) custom function

Returns duplicate values from a list.
( Inspired by Jon Rosen's IdentifyDupes( ) cf1334 )
*/

Let([
$i = $i + 1 ;
value = GetValue ( ValueList ; $i ) ;
$dupes = If ( ValueCount ( FilterValues ( ValueList ; value ) ) > 1 and not ValueCount ( FilterValues ( $dupes ; value ) )  ; List ( value ; $dupes ) ; $dupes )
];
If ( $i ≤ ValueCount ( ValueList ) ; DupesInList ( ValueList ) ; $dupes & Let ( [ $i = "" ; $dupes = "" ] ; "" ) )
)

Returns duplicate values from a list.
( Inspired by Jon Rosen's IdentifyDupes( ) cf1334 )

Comments

		Stathis Askaridis, SICOA Consulting LTD Feb 3, 2020
You shouldn't use $i for the iterations, as it is a commonly used variable, which means the custom function will break $i in scripts.

		Kent Silveira, Kona Koncepts Nov 24, 2020
Greetings, this Custom Function is great. I created a version that uses the While function (rather than recursion). DupValueFinder function. It also addresses StathisÊ»s concern regarding the var $iÊ» for the iterations. I noticed with Let an internal variable doesnÊ»t seem to be recognized unless it is a dollar sign variable. The While function does not seem to have this limitation.

		Kent Silveira, Kona Koncepts Nov 25, 2020
Renamed DupValueFinder to RepeatValueFinder to avoid confusing the two.

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

DupesInList ( ValueList )

Comments

Support this website.

Support this website.