Custom Function help

[thehand6]

Hello all, I would like to know if anyone can help .. I have a wrestling app. in fmp8 that assigns a unique # based on the number of wrestlers within a wht-class... (5 wrestlers in wht-class 125lb) so wrt#1 wrt#2...... wr#5.

Now heres the tricky part... i want to use a custum function to show a list of every wrt# and match it up with every wrt#, without any repeats or matching itself..

1-2

3-4

5-Bye

2-3

4-5

1-Bye

3-5

1-4

2-Bye

1-5

2-4

3-Bye

2-5

1-3

4-Bye

I know there are some functions CombineValues( list1, list2, divider )

that combins all values in two lists but they have repeats and match ...

( 1-1¶5-5) (2-4¶ 4-2 ).. but that will not work in my case.

[comment]

Not a custom function, but might help: Link

[thehand6]

ok that help , but i had to put the wrt#'s into two repeating fields, then use a script to get them to rotate for every round..

rnd1... rnd2... rnd3 ...

1-2... 1-3... 1-4 ...

3-8... 4-2... 5-3 ...

4-7... 5-8... 6-2 ...

5-6... 6-7... 7-8 ...

and for odd # of wrestlers I used a "Bye"

rnd1... rnd2... rnd3 ...

1-2... 1-3... 1-4 ...

3-7... 4-2... 5-3 ...

4-6... 5-7... B-2 ...

5-B... B-6... 6-7 ...

I used a couple CF's to get it to work..

NumRange( From ; To )by Ray Cologon

// to get 1¶2¶3¶4¶5¶6¶7¶8

MinValue( list ; value )byTheo Ros

// find the middle value in the range list

Reverse( text )by Andrew Persons

// reverse list2 list ...9¶8¶7¶6

CombineValues( list1;list2;devider )by Jonathan Stark

//combine both list

1-8

2-7

3-6

4-5

ExtractLine( Field; Number)by Michael Haymore

// used to extract the wrt# from the list

now there has to be away of puting this all in one CF ... any ideas?

[comment]

Maybe there is, but I cannot see the advantage in struggling with a custom function (that does not have a counter) or putting the data in repeating fields, when you can simply make a list of the wrestlers as records, and generate a list of matches as records.

[Raybaudi]

Hi

maybe that I haven't understand you correcty, but give a look to this custom function:

http://www.briandunning.com/cf/276