Function overview
Prototype
DoubleInList (
_values )
Parameters
_values list of values
Description
Tags:
List
Returns values existing more than once in a list
Examples
Sample input
List ( "Albert";"Jean";"Albert";"Jacques";"Albert";"Jean";"Paul";"Patrick";"Alain")
Sample output
Albert
Jean
Function code
/*-------------------------------------
DoubleInList ( _values )
-------------------------------------
By Tanguy Colles BH&A 20121121
-------------------------------------
Returns values existing more than once in a list
-------------------------------------
Recursive Function - > limited
-------------------------------------
*/
Case (
ValueCount ( _values ) > 0 ; List (
If ( ValueCount ( FilterValues ( _values ; GetValue ( _values ; 1 ) ) ) > 1 ;
GetValue ( _values ; 1 ) )
; DoubleInList ( RightValues ( Substitute ( ¶ & _values & ¶ ; ¶ & GetValue ( _values ; 1 ) & ¶; "¶" ) ; ValueCount ( _values ) - 1 ) ) )
)
// ===================================
/*
This function is published on FileMaker Custom Functions
to check for updates and provide feedback and bug reports
please visit http://www.fmfunctions.com/fid/341
Prototype: DoubleInList( _values )
Function Author: Tanguy Colles (http://www.fmfunctions.com/mid/376)
Last updated: 22 November 2012
Version: 1.3
*/
// ===================================
/*-------------------------------------__LITBR__DoubleInList ( _values )__LITBR__-------------------------------------__LITBR__By Tanguy Colles BH&A 20121121__LITBR__-------------------------------------__LITBR__Returns values existing more than once in a list__LITBR__-------------------------------------__LITBR__Recursive Function - > limited__LITBR__-------------------------------------__LITBR____LITBR__*/__LITBR____LITBR____LITBR__Case ( __LITBR__ ValueCount ( _values ) > 0 ; List ( __LITBR__ If ( ValueCount ( FilterValues ( _values ; GetValue ( _values ; 1 ) ) ) > 1 ; __LITBR__ GetValue ( _values ; 1 ) )__LITBR__ ; DoubleInList ( RightValues ( Substitute ( ¶ & _values & ¶ ; ¶ & GetValue ( _values ; 1 ) & ¶; "¶" ) ; ValueCount ( _values ) - 1 ) ) )__LITBR__ )__LITBR____LITBR__// ===================================__LITBR__/*__LITBR____LITBR__ This function is published on FileMaker Custom Functions__LITBR__ to check for updates and provide feedback and bug reports__LITBR__ please visit http://www.fmfunctions.com/fid/341__LITBR____LITBR__ Prototype: DoubleInList( _values )__LITBR__ Function Author: Tanguy Colles (http://www.fmfunctions.com/mid/376)__LITBR__ Last updated: 22 November 2012__LITBR__ Version: 1.3__LITBR____LITBR__*/__LITBR__// ===================================
Comments
22 November 2012
22 November 2012
didn't test it, but how could it be case sensitive? No function is case sensitive in it
22 November 2012
(Edited by Tanguy Colles on 22/11/12 )
22 November 2012
09 August 2014