ordering numeric fields

[Jan Ullrich]

Hello,

I have a number of fields populated with numbers (e.g., 000002, 000054, 005674, etc.). These provide information about frequency in the corpus but also other types of statistics that use in my various databases. When I sort the database by the field with numeric values, ToolBox sorts the entries from lowest to highest, which is the opposite of what I want. I tried introducing a sort order from 9 to 0, but that didn’t solve the problem either.
Is there a way to sort numeric values from lowest to highest?

Jan

 

[Henry Kammler]

Háu kȟolá,

in the default setup for "browse view", "wordlist" type of database go: 
Edit|Sorting...|Fields for Sorting|Sort fields (pick "cz", no kidding, at least with wordlist type)|Sort Order for first field: "Default", tick  option "Sort first field from end"

"Sort first field from end" works in all database types, in my experience, and you can export them in that order into plain text/xml (at export, choose "Current window’s records" (informs you as "Sorted by:[fieldmarker]".


voilá

Henry

--
You received this message because you are subscribed to the Google Groups "Shoebox/Toolbox Field Linguist's Toolbox" group.
To unsubscribe from this group and stop receiving emails from it, send an email to shoeboxtoolbox-field-ling...@googlegroups.com.
To view this discussion visit https://groups.google.com/d/msgid/shoeboxtoolbox-field-linguists-toolbox/005601dce77c%2440212ff0%24c0638fd0%24%40gmail.com.

[Henry Kammler]

Sorry, I was too quick, Toolbox can’t seem to handle alphanumeric reverse ordering. I actually tried a new database type, with the frequency count as record marker (after export and reimport as new DB), to no avail. It seems to force you to set up a sort order lik this (haven’t tried):
0001
0002
0003
.
.
.
9999

But that seems very clumsy and who knows if it can handle config files of 10,000+ lines length.

Now I’m curious myself ...

Henry



Am 19.05.2026 um 12:42 schrieb Jan Ullrich:

--

[Jan Ullrich]

Henry,

Thank you for the quick reply. I did try “Sort field from the end” but that didn’t solve my problem.
I can’t find what you describe as <default setup for "browse view", "wordlist" type of database go>.
I know where to set up browse fields, but I’m not familiar with default setup for “browse view”. Can you point me out to where to find it?

Thanks

Jan

To view this discussion visit https://groups.google.com/d/msgid/shoeboxtoolbox-field-linguists-toolbox/87c1f67e-6df8-40b9-8243-93c1767fd8be%40gmail.com.

[Jan Ullrich]

I did try to set up a numeric sort order by inserting 000001-999999 but Toolbox didn’t manage to save it.

Jan

 

From: shoeboxtoolbox-fiel...@googlegroups.com [mailto:shoeboxtoolbox-fiel...@googlegroups.com] On Behalf Of Henry Kammler

To view this discussion visit https://groups.google.com/d/msgid/shoeboxtoolbox-field-linguists-toolbox/a05a0d60-0794-42cb-a9ce-3d5832967322%40gmail.com.