This may be a more esoteric question than this list can help me with, but hopefully someone can at least point me to somewhere to find an answer.
I’m dealing with a list of filenames that were automatically generated as 24-digit hexadecimal numbers. When they are sorted in a normal alphanumeric sort (such as by the Finder), they aren’t sorted by hex value, but as alphanumeric text. This results in a different order from by actual value. I want them sorted by numeric value.
I’ve been trying to find something (free, low cost, or that I already have) that can batch process these to sort by value, either directly as hex values or with a conversion to decimal. The problem is twofold: one, as I mentioned, they’re 24 digits, which represents a value much higher than most consumer-level products (such as Excel) can handle (in decimal they run into 29 digits, tens of octillions); and two, there’s nearly 5000 of these files, which means converting the numbers one at a time (such as with a calculator) would be a Herculean task.
The filenames were not generated strictly in numeric order chronologically (that is, most of them would be in order by date, but there are a few hundred scattered filenames that for some reason didn’t follow order), so sorting the files by date doesn’t get around the problem.
You don’t need to convert the entire 24-digit hexadecimal string to one large number to sort it. You can break it into smaller strings, such as four six-digit strings, convert each to a numeric value, then sort by multiple numeric fields.