sorting error?

[Albrecht Kadauke 1]

Sorting titles of notes alphabetically ascending of the items below should show this (for instance a LibreOffice result):

Artist

LO24.2

LO7.6

Zyclone

 

Evernote shows this instead:

Artist

LO7.6

LO24.2

Zyclone

 

So the error only comes if numbers are integrated in the note title string.

Is this a known bug?

 

[gazumped 11,737]

7 hours ago, Albrecht Kadauke said:

Is this a known bug?

Hi.  Not one I've seen - I'd suggest you contact https://help.evernote.com/hc/en-us/requests/

[Mike P 2,717]

7 hours ago, Albrecht Kadauke said:

So the error only comes if numbers are integrated in the note title string.

It appears that EN recognises numbers within a text string, so 7.6 comes before 24.2. Change it to LO70.6 and it comes after LO24.2. EN being a bit too clever for it's own good?

[AlbertR 562]

Sorting numbers within strings is a difficult task. We (as developers of an eCad system) often had requirements to sort strings like =A1+P7.1-K17:a and =A1+P24.2-K4:b. Internally you have to split the string to substrings containing only numbers and only other characters (simplyfied). Resulting table of substrings has to be sorted alphabetical in character columns and numerical in numerical columns.

By doing so, 7 comes before 24 . So EN works correct even in this sophisticated area 😉

But this is not true. If EN has to sort strings like "003-test+2" and "03-test+1" it fails:

• first number 3 is identical.
• Second string "-test" is identical.
• Last numbers +2 and +1 should sort as +1..+2.

But the notes are listed as

• 003-test+2
• 03-test+1

At the end it sorts along its own rules - that are not documented anywhere... Best idea so solve this is to insert leading or trailing "0"s according to your sorting needs.