Sorting a string array from any character position

Question

Working with vb 2008 I need to sort an array of strings: (for example:)

dim list1() as String={"CONE0Z08TTTBALL","BARE0U04TTTBALL",  
             "APTN0S01TTTBALL","SPTN0K02TTTBALL"}

sorted from 5th character (not first):

SPTN0K02TTTBALL
VPTN0S01TTTBALL
BARE0U04TTTBALL
CONE0Z08TTTBALL

There is any way using the Array class sort?

but now, VPTN0S01TTTBALL isnt in the list...I get the drift though — Ňɏssa Pøngjǣrdenlarp
– Ňɏssa Pøngjǣrdenlarp, Commented Jan 31, 2016 at 16:15

Community · Accepted Answer · 2017-05-23 12:15:38Z

3

You can use linq to do that. I changed APTN0K02TTTBALL to SPTN0K02TTTBALL since that looks like a typo.

Dim list1() As String = {"CONE0Z08TTTBALL", "BARE0U04TTTBALL",
     "APTN0S01TTTBALL", "SPTN0K02TTTBALL"}
Dim result = list1.OrderBy(Function(q) q.Substring(5)).ToArray

For Each s As String In result
    Console.WriteLine(s)
Next

Output:

SPTN0K02TTTBALL
APTN0S01TTTBALL
BARE0U04TTTBALL
CONE0Z08TTTBALL

Note: If by 5th character, you meant 1-based, change the substring argument (which is 0 based) . Also, this is an alpha sort, so if you want to sort by the value of a numeral, you should also convert to integer. Not sure which you mean.

ryanyuyu kindly wrote you this DotNetFiddle

edited May 23, 2017 at 12:15

CommunityBot

11 silver badge

answered Jan 31, 2016 at 16:03

Ňɏssa Pøngjǣrdenlarp

39k12 gold badges65 silver badges193 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

ryanyuyu Over a year ago

So... as you were working on this answer, I was creating a demo. Since my code ended up being almost identical to yours, you can use it if desired. Demo

Ňɏssa Pøngjǣrdenlarp Over a year ago

nice, I added it. I used to write lots of those, but looking at the view count it seems that VB people never look at them. Odd. @ryanyuyu

Spiromer Over a year ago

Thanks for your help. Numbers are treated as char, so I thing it will work.

Collectives™ on Stack Overflow

Sorting a string array from any character position

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related