Alphabet sorting

Hello,

I have an output file I'm trying to sort ascending on a column that basically lists the alphabet and after 'Z' it transitions to AA, BB, CC, etc. Right now, the sort is placing the double letters at the top, showing as..

Ideally, I'd like the double letter values to sort after the single letter values such as...

Is there a way to accomplish this?

Data Investigation

Accepted answers

DataNath

@Jake5 you could use an approach like this, where you measure the length of the field to get a count which you then sort on before sorting alphabetically on the data field itself:

Alphabet sort with single and double letters.yxmd

binu_acs

@Jake5 One way of doing this

Sort_1026.yxmd

All comments

DataNath

@Jake5 you could use an approach like this, where you measure the length of the field to get a count which you then sort on before sorting alphabetically on the data field itself:

Alphabet sort with single and double letters.yxmd

binu_acs

@Jake5 One way of doing this

Sort_1026.yxmd

Jake5

Thank you both!

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703