OrderedPairs ( listOfValues )

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

Average rating: 4.6 (24 votes) Log in to vote

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

Sample input:

a
b
c

Sample output:

ab
ba
ac
ca
bc
cb

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

/*
OrderedPairs ( listOfValues ) custom function
Author: Daniele Raybaudi
*/

Let([
$cfOrderedPairs = $cfOrderedPairs + 1 ;
v1= GetValue ( listOfValues ; 1 );
vn = GetValue ( listOfValues ; $cfOrderedPairs + 1 );
c = ValueCount ( listOfValues ) ;
next = RightValues ( listOfValues ; c - 1 )
];
Case(
$cfOrderedPairs < c ; List ( v1 & vn ; List ( vn & v1 ; OrderedPairs ( listOfValues ) ) ) ;
Let ( $cfOrderedPairs = "" ; If ( ValueCount ( next ) ; OrderedPairs ( next ) ) )
)
)

Enumerates all possible combinations of two values that can be selected from the given list of values, with 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.

OrderedPairs ( listOfValues )

Comments

Support this website.

Support this website.