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 be like "1" "3" "5" "6" "9" "11" "NUM0" "NUM1" is there any idea to do this using LINQ or Lambda expression? Thanks in advance ...

Writing a better natural sort (than mine)

I added an answer to this question here: Sorting List<String> in C# which calls for a natural sort order, one that handles embedded numbers. My implementation, however, is naive, and in lieu of all the posts out there about how applications doesn't handle Unicode correctly by assuming things (Turkey test anyone?), I thought I'd ask for ...

sql sort numeric then alphabetically

in this example : 10-20 20-40 50-60 v k r a 12 month 1 month how can i sort it in this order ?: 10-20 20-40 50-60 a k r v 1 month 12 month i use abs(value) but in the alphabetical case doesn't work ...

How make for order by name in MYSQL as with order name in Window

table Picture with rows have name 1.jpg,2.jpg,3.jpg,4.jpg,5.jpg,6.jpg,7.jpg,8.jpg,9.jpg,10.jpg,11.jpg select * from Picture order by name mysql order : 1.jpg,10.jpg,11.jpg,2.jpg,3.jpg,...... Issue: I want it sort all type name like as with Window 1.jpg,2.jpg,3.jpg,4.jpg,5.jpg,6.jpg,7.jpg,8.jpg,9.jpg,10.jpg,11.jpg and it must worki...

How to achieve Natural(human alpha-numeric ) Sorting, for silverlight datagrids using ViewModel?

In silverlight project that uses datagrid, I am using some column that defines "Label number" which is a Varchar. I want to sort this column as described in natural sort order as described in "http://www.interact-sw.co.uk/iangblog/2007/12/13/natural-sorting" or any possible way. When I look around datagrid I saw SortMemberPath="strin...