Unknown character order
I am sorting a large list of values and I am using the sort.exe file (site here , zip file with sort.exe here) which is a UNIX port of 'sort' for Windows. However, I cannot figure out in what order it sorts it. So, I took a list of ASCII characters and ran the sort file to see how it was created. Does anyone know what character order this is, or more precisely, how can I implement it in Python?
Edit : chcp was originally 437 (US), I also tried with 65001 (Unicode), both gave me the same result.
╔═══════╦══════════╗
║ ASCII ║ SORT.EXE ║
╠═══════╬══════════╣
║ ! ║ ' ║
║ " ║ - ║
║ # ║ ! ║
║ $ ║ " ║
║ % ║ # ║
║ & ║ $ ║
║ ' ║ % ║
║ ( ║ & ║
║ ) ║ ( ║
║ * ║ ) ║
║ + ║ * ║
║ , ║ , ║
║ - ║ . ║
║ . ║ / ║
║ / ║ : ║
║ 0 ║ ; ║
║ 1 ║ ? ║
║ 2 ║ @ ║
║ 3 ║ [ ║
║ 4 ║ \ ║
║ 5 ║ ] ║
║ 6 ║ ^ ║
║ 7 ║ _ ║
║ 8 ║ ` ║
║ 9 ║ { ║
║ : ║ | ║
║ ; ║ } ║
║ < ║ ~ ║
║ = ║ + ║
║ > ║ < ║
║ ? ║ = ║
║ @ ║ > ║
║ A ║ 0 ║
║ B ║ 1 ║
║ C ║ 2 ║
║ D ║ 3 ║
║ E ║ 4 ║
║ F ║ 5 ║
║ G ║ 6 ║
║ H ║ 7 ║
║ I ║ 8 ║
║ J ║ 9 ║
║ K ║ a ║
║ L ║ A ║
║ M ║ b ║
║ N ║ B ║
║ O ║ c ║
║ P ║ C ║
║ Q ║ d ║
║ R ║ D ║
║ S ║ e ║
║ T ║ E ║
║ U ║ f ║
║ V ║ F ║
║ W ║ g ║
║ X ║ G ║
║ Y ║ h ║
║ Z ║ H ║
║ [ ║ i ║
║ \ ║ I ║
║ ] ║ j ║
║ ^ ║ J ║
║ _ ║ k ║
║ ` ║ K ║
║ a ║ l ║
║ b ║ L ║
║ c ║ m ║
║ d ║ M ║
║ e ║ n ║
║ f ║ N ║
║ g ║ o ║
║ h ║ O ║
║ i ║ p ║
║ j ║ P ║
║ k ║ q ║
║ l ║ Q ║
║ m ║ r ║
║ n ║ R ║
║ o ║ s ║
║ p ║ S ║
║ q ║ t ║
║ r ║ T ║
║ s ║ u ║
║ t ║ U ║
║ u ║ v ║
║ v ║ V ║
║ w ║ w ║
║ x ║ W ║
║ y ║ x ║
║ z ║ X ║
║ { ║ y ║
║ | ║ Y ║
║ } ║ z ║
║ ~ ║ Z ║
╚═══════╩══════════╝
source to share
It is very similar to sort -df
( -d
for dictionary order, -f
for ignore case) on the GNU sort
I have. However, '
and -
are at the top. It looks like it might have been solved in the comments, but for future reference:
To sort the rows in the custom procedure in Python, one of the ways is to use maketrans()
, and translate()
your order key, for example:
ascii = '!"#$%&\'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\\]^_`abcdefghijklmnopqrstuvwxyz{|}~'
mapped = '\'-!"#$%&()*,./:;?@[\\]^_`{|}~+<=>0123456789aAbBcCdDeEfFgGhHiIjJkKlLmMnNoOpPqQrRsStTuUvVwWxXyYzZ'
trans = str.maketrans(mapped, ascii)
print("".join(sorted(ascii, key=lambda s: s.translate(trans)))) # prints mapped
source to share