egghelp.org community

[oxygen]

Hello all.

I need some help to sort my database.
My database is formatted like this:
A1,B1,C1,D1 A2,B2,C2,D2 A3,B3,C3,D3 and so on...
Example:
345,nick1,23,56 333,nick2,22,3 200,nick3,4,3
I sort this with:

[Sir_Fz]

Since you have the -decreasing switch, c3 will come before c2 c1 b3...etc (that's because tha ASCII representation of c is greater than b) so if you remove that switch, the order of the letters will become increasing (from a to z) but the numbers will probably come first (also from least to greatest).
_________________
Follow me on GitHub

- Opposing

Public Tcl scripts

[oxygen]

Hello

I'll try to explaine it better. The database is part of a trivia game.
The first item is the yearly score, third item monthly score and so on.
With the above code the database is sorted by the first item, the yearly score. When I do a top 10 then it counts the yearly score. What I want is a top 10 score with the third item, the monthly score. How can I sort the database to do this?

Regards,
~oxygen

[ZeRoMe]

To sort correctly your score you must place item in first place, for exemple:
345,nick1,23,56
To order by item 4 (56) place this in first position:
56,345,nick1,23
Use split and lindex commands.