Top "Natural-sort" questions

Natural sorting is ordering things the way a human would.

Sort string as number in sql server

I have a column that contains data like this. dashes indicate multi copies of the same invoice and these have …

sql sorting sql-server-2008-r2 natural-sort
PostgreSQL ORDER BY issue - natural sort

I've got a Postgres ORDER BY issue with the following table: em_code name EM001 AAA EM999 BBB EM1000 CCC …

sql postgresql types sql-order-by natural-sort
how to sort varchar numeric columns by DESC or ASC?

I write ... ORDER BY column ASC but my column is VARCHAR and it sorts wrong like 1, 10, 2, instead of 1, 2, 10. How can …

mysql sql-order-by natural-sort
how to sort strings in javascript numerically

I would like to sort an array of strings (in javascript) such that groups of digits within the strings are …

javascript regex sorting split natural-sort
Sorting List<String> in C#

How to sort a List based on the item's integer value The list is like "1" "5" "3" "6" "11" "9" "NUM1" "NUM0" The result should …

c# natural-sort
Sort filenames naturally with Qt

I am reading a directories content using QDir::entryList(). The filenames within are structured like this: index_randomNumber.png I …

c++ qt natural-sort
How to implement a natural sort algorithm in c++?

I'm sorting strings that are comprised of text and numbers. I want the sort to sort the number parts as …

c++ sorting natural-sort
How do I sort a VARCHAR column in PostgreSQL that contains words and numbers?

I need to order a select query using a varchar column, using numerical and text order. The query will be …

sql postgresql jdbc natural-sort
LINQ and a natural sort order

What's the easiest way to get a LINQ query (from an SQL database - does that matter?) to order strings …

c# linq natural-sort
How to compare version string ("x.y.z") in MySQL?

I have firmware version strings into my table (like "4.2.2" or "4.2.16") How can I compare, select or sort them ? I cannot …

python mysql sql django natural-sort