Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Is there a way to sort a glacial list numerically - as opposed to alphabetically?

Posted on 2008-10-25
1
Medium Priority
?
360 Views
Last Modified: 2008-10-26
Hello,

I have a glacial list that I need to sort.

I've been doing it like this:

this.myGlacialList.SortType = GlacialComponents.Controls.SortTypes.QuickSort;

Only problem I'm having is that I need for it to sort numerically rather than alphabetically.

When I put numbers in a column like so:  1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11

and then click on the column header to sort them, it sorts them alphabetically, so the result is this:

1, 10, 11, 2, 3, 4, 5, 6, 7, 8, 9

Is there any way to do this in numeric order?

Thanks in advance,
Tim
0
Comment
Question by:tmitch68
1 Comment
 
LVL 31

Accepted Solution

by:
moorhouselondon earned 2000 total points
ID: 22806511
You could pad all numbers with a fixed number of zeroes - the number of zeroes dependent on the max number of entries in your list e.g.,

01 02 03 04 05 ... for a list extending up to 99
001 002 003 004 ... for a list extending to 999

Alternatively, define the column as a numeric column (depending on what app you are using)
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If you’re thinking to yourself “That description sounds a lot like two people doing the work that one could accomplish,” you’re not alone.
We live in a world of interfaces like the one in the title picture. VBA also allows to use interfaces which offers a lot of possibilities. This article describes how to use interfaces in VBA and how to work around their bugs.
Starting up a Project
Screencast - Getting to Know the Pipeline

927 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question