Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

How can I sort a-z ignoring spaces and hyphens, please?

Items in a book index of 6000 items

aa b,
aa c,

aa-b,
aa-c,

aaab,
aab,

aac,

so sorted, must appear instead as

aaab,

aa b,
aa-b,
aab,

aa c,

aa-c,

aac

click to hide/show revision 2
No.2 Revision

How can I sort a-z ignoring spaces and hyphens, please?

Items in a book index of 6000 items

aa b, 
aa c,

c, aa-b, aa-c, aaab,

aa-b,
aa-c,

aaab,
aab,

aac,

aab, aac,

so sorted, must appear instead as

aaab, 

aa b,
aa-b,
aab,

aab, aa c,

aa-c,

aac

c, aa-c, aac