UnorderedPairs ( listOfValues )

Returns a list of all unordered pairs that can be selected from list of values.

Average rating: 4.9 (27 votes) Log in to vote

Michael Horak - Show more from this author
*COMMENT Visual Realisation

Sample input:

a
b
c
d
e

Sample output:

{ a ; b }
{ a ; c }
{ a ; d }
{ a ; e }
{ b ; c }
{ b ; d }
{ b ; e }
{ c ; d }
{ c ; e }
{ d ; e }

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

/*
UnorderedPairs function

Author
*COMMENT Visual Realisation

Format
UnorderedPairs ( listOfValues )

Parameters
listOfValues - any text expression or text field

Data type returned
text

Description
Enumerates all possible combinations of two values that can be selected from the given list of values, with no significance attached to the internal order of values in a pair.

February 17, 2014
*/

Let ( [
countValues = ValueCount ( listOfValues ) ;
item = GetValue ( listOfValues ; 1 ) ;
others = RightValues ( listOfValues ; countValues - 1 ) ;

open = "{ " ;
separator = " ; " ;
close = " }" 
] ;
Case ( countValues > 1 ; 
open & item & separator & Substitute ( others & ¶ ; [ "¶¶" ; close ] ; [ ¶ ; close & ¶ & open & item & separator ] )
& ¶ &
UnorderedPairs ( others )
)
)

Enumerates all possible combinations of two values that can be selected from the given list of values, with no significance attached to the internal order of values in a pair.

Comments

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

UnorderedPairs ( listOfValues )

Comments

Support this website.

Support this website.