RandomList ( ListToRandom )

To mix a list (random result) (Shuffle)

Average rating: 4.7 (35 votes) Log in to vote

Agnes Barouh - Show more from this author
Tic Tac
http://www.tictac.fr/CoinFileMaker/Page.html

Sample input:

RandomList ( "Monday¶Tuesday¶Wednesday¶Thursday" )

Sample output:

Random result :
Tuesday¶Wednesday¶Monday¶Thursday
or
Thursday¶Monday¶Tuesday¶Wednesday
or ....

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

// RandomList ( ListToRandom ) v2.0
// requires CustomList ( start ; End ; Function )
// http://www.briandunning.com/cf/868

       /*
             To mix a list (random)
      */

//---------------------------------- Exemple
// List_A contains "A¶B¶C¶D"  -> Result : "B¶D¶A¶C" or "A¶D¶B¶C" or ....

//-------------------------------------------------------------------*/
// Agnès Barouh - January 2008 - To report bugs :  barouh.agnes@wanadoo.fr
//-------------------------------------------------------------------*/

Let([

$Rc = ¶ ;
$RL_MaListe = ListToRandom

];
CustomList ( 1 ; ValueCount ( $RL_MaListe ) ;
"Let ([
Nbr = Int ( Random * ValueCount ( $RL_MaListe ) ) + 1 ;
Pos = Position ( $rc & $RL_MaListe ; $Rc ; 1 ; Nbr ) ;
Value = GetValue ( $RL_MaListe ; Nbr ) ;
$RL_MaListe = Replace ( $RL_MaListe ; Pos ; Length ( Value ) + 1 ; \"\" )] ; Value )" )
)

To mix a list (random result) [make a list in the chaos]

- Keeps duplicates datas

- Shuffle

-----------------------------------------
it is not a recursive function
Requires CustomList ( start ; End ; Function )
-----------------------------------------

Comments

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

RandomList ( ListToRandom )

Comments

Support this website.

Support this website.