Newest functions Upload a function Leave a tip My account

There are 2,570 functions in this library.

FiveCharsPermutations ( text ; number )

Returns all 120 simple permutations of the five characters of the field

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

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

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

/* Custom Function: FiveCharsPermutations Format: FiveCharsPermutations(text;number) Autor: Daniele Raybaudi Returns all 120 permutations of the five characters of the field "text" The "number" parameter must be set to 0 */ Let([ start = 12345 + number; end =54321 ]; Case( Length(text) ≠ 5;"error"; Length(Filter("12345";start)) = 5 ;Substitute ( start ; [1 ; Middle( text ;1;1 )];[2;Middle ( text ;2;1 )]; [3 ; Middle( text ;3;1 )]; [4 ; Middle( text ;4;1 )]; [5 ; Middle( text ;5;1 )]) & "¶" & FiveCharsPermutations(text;number + 9); start ≤ end;FiveCharsPermutations(text;number + 9) ) ) Click to copy

Returns all 120 permutations of the five characters of the field "text"
The "number" parameter must be set to 0

 

Comments

Log in to post comments.

 

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

Support this website.

This library has been a free commmunity resource for FileMaker users and developers for 20 years. It receives no funding and has no advertisements. If it has helped you out, I'd really appreciate it if you could contribute whatever you think it's worth: