Here's a goofy idea.

As long as you don't have any decimals in your list - that your list is all
ranges of integers -

I'm assuming you're extracting 1-5, 6-8 etc. from your DB, and they're all
in the same field.

So do a ValueList() on that field, so you end up with a list:

1-5,14-18,6-8

Then Replace() on that list, changing - to .

1.5,14.18,6.8

Then sort that list numerically using ListSort():

1.5,6.8,14.18

then Replace() again, . to -

1-5,6-8,14-18

--Scott
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

Reply via email to