Sorting norwegian language

%3CLINGO-SUB%20id%3D%22lingo-sub-3192989%22%20slang%3D%22en-US%22%3ESorting%20norwegian%20language%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3192989%22%20slang%3D%22en-US%22%3E%3CP%3EIn%20the%20norwegian%20language%20we%20have%20the%20extra%20letters%20%C3%A6%2C%C3%B8%20and%20%C3%A5%20which%20are%20sorted%20at%20the%20end%20(after%20z).%20But%20-%20'aa'%20can%20also%20be%20used%20to%20represent%20%C3%A5.%26nbsp%3B%3C%2FP%3E%3CP%3EMy%20problem%20is%20that%20I%20have%20a%20list%20of%20values%20that%20happens%20to%20have%20to%20adjacent%20instances%20of%20a%20-%20and%20I%20want%20them%20to%20be%20sorted%20as%20such%20and%20not%20as%20%C3%A5%20(aa)%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESo%2C%20I%20want%20to%20sort%20the%20values%20like%20this%3C%2FP%3E%3CP%3EAATEST%3C%2FP%3E%3CP%3ENEW%3C%2FP%3E%3CP%3ETEST%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhat%20actually%20happens%20is%3C%2FP%3E%3CP%3ENEW%3C%2FP%3E%3CP%3ETEST%3C%2FP%3E%3CP%3EAATEST%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20suggestions%3F%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3192989%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

In the norwegian language we have the extra letters æ,ø and å which are sorted at the end (after z). But - 'aa' can also be used to represent å. 

My problem is that I have a list of values that happens to have to adjacent instances of a - and I want them to be sorted as such and not as å (aa) 

 

So, I want to sort the values like this

AATEST

NEW

TEST

 

What actually happens is

NEW

TEST

AATEST

 

Any suggestions? 

0 Replies