GroupListItems ( MyList )

Group and count repeating items in a list

Average rating: 5.0 (1 vote) Log in to vote

flusheDData - Show more from this author
n/a
http://www.udias.com

Sample input:

GroupListItems ( "green¶blue¶blue¶red¶black¶blue¶dark blue¶green¶black" )

Sample output:

green (2)
blue (3)
red (1)
black (2)
dark blue (1)

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

Let ( 
[ 
$counter = $counter + 1 ; 
$item = GetValue ( MyList ; $counter ) & " (" & ValueCount ( FilterValues (  MyList ; GetValue ( MyList ; $counter  ) ) ) & ")" ;  
$result = $result & Case ( IsEmpty ( FilterValues ( $result ; $item ) ) ;  ¶ & $item )

] ; 
Case( 
$counter < ValueCount ( MyList ) ; 
GroupListItems ( MyList ) ; 
Let ( [ 
_result = $result ; 
$result = "" ; 
$item = "" ; 
$counter = ""
] ; 
Evaluate ( "List (  \"" & Substitute ( _result ; ¶ ; "\" ; \"" ) & "\" )" )
) 
)
)

/*
flusheDData 2021 
*/

A tail recursion function which groups and counts repeating items in a list.

Comments

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

GroupListItems ( MyList )

Comments

Support this website.

Support this website.