Forum Discussion
Solved
Correctly sort a list of text
Hi guys, I have a list like the picture below. If I use List.Sort, the result is like below Is there any way to correctly sort this list into {Column1, Column2, ..., Column10, Column...
Hi mpi_gov_vn,
You can provide a function as the 2nd argument of List.Sort, that transforms each value into the value to sort by.
In your case this should work:
List.Sort( YourList, each Number.From( Text.AfterDelimiter( _, "Column" ) ) )
OwenAuger
Super User
Super UserHi mpi_gov_vn,
You can provide a function as the 2nd argument of List.Sort, that transforms each value into the value to sort by.
In your case this should work:
List.Sort( YourList, each Number.From( Text.AfterDelimiter( _, "Column" ) ) )Works like a charm! Thanks OwenAuger
