FiveFieldsPermutations ( field1 ; field2 ; field3 ; field4 ; field5 ; number )

Returns all 120 simple permutations of the contents of five fields

Average rating: 4.2 (31 votes) Log in to vote

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

Sample input:

field1="a "
field2="the "
field3="killer "
field4="man "
field5="killed "

Sample output:

...among all the 120 permutations:
the killer killed a man
the man killed a killer
...

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

/*
Custom Function: FiveFieldsPermutations
Format:FiveFieldsPermutations(field1;field2;field3;field4;field5;number)
Autor: Daniele Raybaudi
Returns all 120 permutations of the contents of five fields
The "number" parameter must be set to 0
*/
Let([
start = 12345 + number;
end =54321
];
Case(
Length(Filter("12345";start)) = 5 ;Substitute ( start ;[1;field1];[2;field2]; [3;field3];[4;field4];[5;field5]) & "¶" & FiveFieldsPermutations(field1;field2;field3;field4;field5;number + 9);
start ≤ end;FiveFieldsPermutations(field1;field2;field3;field4;field5;number + 9)
)
)

Returns all 120 permutations of the contents of five fields.
The "number" parameter must be set to 0

Comments

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

FiveFieldsPermutations ( field1 ; field2 ; field3 ; field4 ; field5 ; number )

Comments

Support this website.

Support this website.