LINQ Ordering a Varcharcolumn which has Number appended to string

Question

0.00/5 (No votes)

See more:

Hi,

I'm new to LINQ concept the requirement what i have is, I have a string column with data as below

OR0
OR1
OR2
.
.
OR9
.
.
OR21
ORD

Now i want to order it as above, but when i do order by i get data as below as it is ordering as string

OR0
OR1
OR10
OR11
OR12
.
.
OR19
OR20
OR21
OR3
.
.
OR9
ORD

Which is wrong as per my requirement.

I tried ordering as Order By Len(Col),Col and the o/p what i received is

OR0
.
.
OR9
ORD
OR10
.
.
OR21

Can any one help me with giving me a proper Order By statement for LINQ statement?

Regards,
Kishan

Posted 19-Jan-11 2:25am

kishan NM

Add a Solution

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

#realJSOP · Answer 1 · 2011-01-19T02:35:00

Solution 1

As you've already no doubt found out, your sorted list would come out like this:

OR1
OR10
OR11
OR12
OR2
OR3

I would add another property to the object being sorted, which represents the integer following the alpha characters, and sort on that property instead.

Posted 19-Jan-11 2:35am

#realJSOP

Updated 19-Jan-11 2:36am

v2

Nish Nishant · Answer 2 · 2011-01-19T03:40:00

Solution 2

I don't know the VB syntax to do this, but with LINQ it would be fairly trivial to write a custom comparer that will take the numeric portion, sort on that, and return a collection that will be sorted as you want it to.

Posted 19-Jan-11 3:40am

Nish Nishant

Hiren solanki · Answer 3 · 2011-01-19T23:05:00

My previous answer got deleted because of some misunderstanding.

posting my answer again.

As per john said it's all correct but if you want to go to find it anyway then I have a trick for you.

Suppose your data is in List<string></string> for applying linq operation.

So you can get sorted data for your case with Linq like,

C#

List<string> list = new List<string>();
..
..
var SortedList  = from l in list
                  orderby l.ToString()+"0"
                  select l;