Re^4: Data with Letter(s) & Number sort query

That is very useful but not quite what I wanted.
In your output, the primary sort are the numbers and the secondary are the letters.
I wanted it the other way around. Therefore all the data with A or a at the front would come before the data with B and so on. Therefore it would be (to start)

A130
a130
A250
A250
A1180
B1105
b1255
B2480
etc
[download]

Comment on Re^4: Data with Letter(s) & Number sort query Download Code

Replies are listed 'Best First'.
Re^5: Data with Letter(s) & Number sort query by hippo (Archbishop) on Nov 19, 2016 at 14:21 UTC
I wanted it the other way around. Perhaps now would be a good opportunity for you to spend a little time understanding the code samples within this thread so that you could make the (minor) changes necessary to produce the specific sorting which you require. Hint 1: sort Hint 2: FAQ: How do I sort an array by (anything)?	[reply]
Re^5: Data with Letter(s) & Number sort query by Laurent_R (Canon) on Nov 19, 2016 at 16:08 UTC
Hint 3: the only thing you need to change to my earlier script is the code line with the sort. The new code line should have exactly the same characters, but not quite in the same order.	[reply]