Solved

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

Posted on 2008-10-25
1
354 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 500 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

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
splitOdd10 challenge 5 125
Recommendation vb6 to vb.net or others 14 200
Help Required 2 46
Output in PHP throwing alignment of data off issue 12 53
Entering a date in Microsoft Access can be tricky. A typo can cause month and day to be shuffled, entering the day only causes an error, as does entering, say, day 31 in June. This article shows how an inputmask supported by code can help the user a…
A short article about problems I had with the new location API and permissions in Marshmallow
Viewers will learn how to properly install Eclipse with the necessary JDK, and will take a look at an introductory Java program. Download Eclipse installation zip file: Extract files from zip file: Download and install JDK 8: Open Eclipse and …
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…

685 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