Need to alphabetise a checkbox list result

[Pat]

I have a checkbox field of five responses, A through E. The order in which users check does influence what is produced. For example, they check box A, B, then C gives the following:

A

B

C

with a carriage return after A and B.

If the user were to check B, then C, then A, the following is returned:

B

C

A

with a carriage return after B and C.

My question is this: is there a way through calculations to alphabatise the response, so that each of the above examples are "ABC'?

Thanks for your help!

Edited January 2, 2008 by Guest
I can't spell!

[Ocean West]

use a custom function to auto replace the field to sort in the correct order.

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

[comment]

Try:

FilterValues ( ValueListItems ( Get (FileName) ; "YourValueList" ) ; Checkboxfield )

[Søren Dyhr]

Ehm!

http://www.filemaker.com/help/FunctionsRef-346.html

...is available under fm8.5

If you put ValueListItems( in the first paramter, and the checkbox field in the second one, will each of ValueListItems( drop thru if it occures in the checkbox field.

Returns a text result containing only the values that were provided in filterValues, in the order that they were originally entered in textToFilter. If filterValues doesn't have any values, an empty string is returned.

Why should we then not just have a party and remake each function with our own versions? If we're talking CF's could you be sure a control mechanism secures against reaching the iteration max this means extra things on each cycle.

In a broarder sence could each function have methods in common even though they exist in each their own function, this is a overhead which years and years of debugging obviously have been removed to make each individual function as lean as possible.

--sd