Solved

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

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

How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
sumHeights  challenge 17 61
Excel object stays open 19 65
count8 challlenge 13 87
Not needed 13 58
Does the idea of dealing with bits scare or confuse you? Does it seem like a waste of time in an age where we all have terabytes of storage? If so, you're missing out on one of the core tools in every professional programmer's toolbox. Learn how to …
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.
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 fourth video of the Xpdf series, we discuss and demonstrate the PDFinfo utility, which retrieves the contents of a PDF's Info Dictionary, as well as some other information, including the page count. We show how to isolate the page count in a…

744 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now