Alphanumeric sorting using LINQ

by

That is because the default ordering for string is standard alpha numeric dictionary (lexicographic) ordering, and ABC11 will come before ABC2 because ordering always proceeds from left to right.

To get what you want, you need to pad the numeric portion in your order by clause, something like:

 var result = partNumbers.OrderBy(x => PadNumbers(x));

where PadNumbers could be defined as:

public static string PadNumbers(string input)
{
    return Regex.Replace(input, "[0-9]+", match => match.Value.PadLeft(10, '0'));
}

This pads zeros for any number (or numbers) that appear in the input string so that OrderBy sees:

ABC0000000010
ABC0000000001
...
AB0000000011

The padding only happens on the key used for comparison. The original strings (without padding) are preserved in the result.

Note that this approach assumes a maximum number of digits for numbers in the input.

More Related Contents:

  1. Preserving order with LINQ
  2. Sort a list from another list IDs
  3. How do I sort strings alphabetically while accounting for value when a string is numeric?
  4. LINQ order by null column where order is ascending and nulls should be last
  5. List sort based on another list
  6. The data source does not support server-side data paging
  7. LINQ Custom Sort
  8. List complex sorting
  9. Sort one list by another
  10. Better way to sort array in descending order
  11. Use LINQ to move item to top of list
  12. Get a list greater than specific value from lists usinq linq c#
  13. How to have nested query with LINQ
  14. LEFT OUTER JOIN in LINQ
  15. Check whether an array is a subset of another
  16. How do I concatenate two arrays in C#?
  17. How to perform Join between multiple tables in LINQ lambda
  18. Sorting rows in a data table
  19. A specified Include path is not valid. The EntityType does not declare a navigation property with the name *
  20. LINQ, Where() vs FindAll()
  21. Is there an “Explain Query” for MongoDB Linq?
  22. What does this C# code with an “arrow” (=>, an equal sign and greater than sign) mean and how is it called?
  23. Using Linq Except not Working as I Thought
  24. What is the purpose of AsQueryable()?
  25. Calling a SQL User-defined function in a LINQ query
  26. How to set property value using Expressions? [duplicate]
  27. Should the order of LINQ query clauses affect Entity Framework performance?
  28. Transform IEnumerable asynchronously by awaiting each task
  29. Map two lists into a dictionary in C#
  30. How to check if all list items have the same value and return it, or return an “otherValue” if they don’t?

Leave a Comment