How to SORT by word length?

[shady]

This is my first post so be nice.

How can I sort by word length.

Example:

at

hat

a

here

television

alarm

sorted -->

a

at

hat

here

alarm

television

I haven't used FM since 1990 so I am rusty!

Edited January 18, 2006 by Guest

[Raybaudi]

Hi

make a new calculation field (WordLength) and calc:

Length(item)

and then sort by it !

P.S.: if you wish an alphabetical order too, sort by it and by items

[BrentHedden]

Yea, Daniele had the same idea that I did. The only thing that I can add to this is to make sure the calculation result is in a number format, and not a text.

[shady]

Thanks you two. It took me a little while to get the Filemaker thinking cap going again.

But I got it done. THANKS!!!