StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
3717036
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
1
CommunityOwnedDate
CreationDate
2010-09-15T11:12:08.830
FavoriteCount
0
LastActivityDate
2010-09-15T11:12:08.830
LastEditDate
LastEditorUserId
0
OwnerUserId
267
ParentId
3716831
PostTypeId
2
Score
16
ViewCount
0
LastEditorDisplayName
text
Body
This is called a "natural sort order", and is usually employed to sort items like those you have, like filenames and such. Here's a naive (in the sense that there are probably plenty of unicode-problems with it) implementation that seems to do the trick: You can copy the code below into <a href="http://www.linqpad.net/" rel="noreferrer">LINQPad</a> to execute it and test it. Basically the comparison algorithm will identify numbers inside the strings, and handle those by padding the shortest one with leading zeroes, so for instance the two strings <code>"Test123Abc"</code> and <code>"Test7X"</code> should be compared as though they were <code>"Test123Abc"</code> and <code>"Test007X"</code>, which should produce what you want. However, when I said "naive", I mean that I probably have tons of real unicode problems in here, like handling diacritics and multi-codepoint characters. If anyone can give a better implementation I would love to see it. Notes: <ul> <li>The implementation does not actually parse the numbers, so arbitrarily long numbers should work just fine</li> <li>Since it doesn't actually parse the numbers as "numbers", floating point numbers will not be handled properly, "123.45" vs. "123.789" will be compared as "123.045" vs. "123.789", which is wrong.</li> </ul> Code: <pre><code>void Main() { List<string> input = new List<string> { "1", "5", "3", "6", "11", "9", "A1", "A0" }; var output = input.NaturalSort(); output.Dump(); } public static class Extensions { public static IEnumerable<string> NaturalSort( this IEnumerable<string> collection) { return NaturalSort(collection, CultureInfo.CurrentCulture); } public static IEnumerable<string> NaturalSort( this IEnumerable<string> collection, CultureInfo cultureInfo) { return collection.OrderBy(s => s, new NaturalComparer(cultureInfo)); } private class NaturalComparer : IComparer<string> { private readonly CultureInfo _CultureInfo; public NaturalComparer(CultureInfo cultureInfo) { _CultureInfo = cultureInfo; } public int Compare(string x, string y) { // simple cases if (x == y) // also handles null return 0; if (x == null) return -1; if (y == null) return +1; int ix = 0; int iy = 0; while (ix < x.Length && iy < y.Length) { if (Char.IsDigit(x[ix]) && Char.IsDigit(y[iy])) { // We found numbers, so grab both numbers int ix1 = ix++; int iy1 = iy++; while (ix < x.Length && Char.IsDigit(x[ix])) ix++; while (iy < y.Length && Char.IsDigit(y[iy])) iy++; string numberFromX = x.Substring(ix1, ix - ix1); string numberFromY = y.Substring(iy1, iy - iy1); // Pad them with 0's to have the same length int maxLength = Math.Max( numberFromX.Length, numberFromY.Length); numberFromX = numberFromX.PadLeft(maxLength, '0'); numberFromY = numberFromY.PadLeft(maxLength, '0'); int comparison = _CultureInfo .CompareInfo.Compare(numberFromX, numberFromY); if (comparison != 0) return comparison; } else { int comparison = _CultureInfo .CompareInfo.Compare(x, ix, 1, y, iy, 1); if (comparison != 0) return comparison; ix++; iy++; } } // we should not be here with no parts left, they're equal Debug.Assert(ix < x.Length || iy < y.Length); // we still got parts of x left, y comes first if (ix < x.Length) return +1; // we still got parts of y left, x comes first return -1; } } } </code></pre>
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POSorting List<String> in C#
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. This table or related slice is empty.
UserOwnerUserId
1. USLasse Vågsæther Karlsen
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. This table or related slice is empty.
VotesPostIdCreationDate
1. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
2. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
3. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
CommentsPostId
1. COI've opened a question to find out a better way to handle diacritics and multi-codepoint characters, here: http://stackoverflow.com/questions/3717132/writing-a-better-natural-sort
 singulars
 PostPostId
 PO
 UserUserId
 USLasse Vågsæther Karlsen

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.