By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
445,705 Members | 1,815 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 445,705 IT Pros & Developers. It's quick & easy.

Need help with a sort

P: n/a
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

Dec 7 '06 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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

Dec 7 '06 #2

P: n/a
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

Dec 7 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.