Need help with a sort

[gonzocanuck]

Hi guys,

I need some help performing a sort. I tried searching Google and Google
Groups, but maybe I'm asking the wrong question or using the wrong
terminology, so I'll explain it.

I have a database of a list of words, such as:

horse
dog
bird
giraffe

I need to sort them by the length of the text, so that they appear
like:

dog
bird
horse
giraffe

I thought that searching for something along the lines of "sort" and
"character length" would yield me an answer. Is this what I would be
looking for? What sort of filter or query can I run to get the desired
result?

Thanks much,
Christine

[Darryl Kerkeslager]

Use the Len() function to get the length of the string, then just sort on
that value, in an array or table.

--
Darryl Kerkeslager

<go*********@gmail.comwrote

I need some help performing a sort. I tried searching Google and Google
Groups, but maybe I'm asking the wrong question or using the wrong
terminology, so I'll explain it.

I have a database of a list of words, such as:

horse
dog
bird
giraffe

I need to sort them by the length of the text, so that they appear
like:

dog
bird
horse
giraffe

I thought that searching for something along the lines of "sort" and
"character length" would yield me an answer. Is this what I would be
looking for? What sort of filter or query can I run to get the desired
result?

Thanks much,
Christine

[gonzocanuck]

Hi Darryl,

Thanks so much for pointing me in the right direction :-) I wasn't
aware of that function.

Using Expr1:Len([FieldName]) in the advanced filter/sort did the trick.

Best,
Christine