Sort document alpha numerically so 6500K999 is before 6500K1000
I've attached a screenshotIn the document list the sorting happens per character so that 6500K100 is followed by 6500K1000 followed by 6500K101. In windows these are sorted as I would like, with the 1000 following the others. Windows is able to parse the string to recognize sub strings as complete numbers to put files in the order a human would in the filing cabinet. I've attached a screenshot of a windows explorer showing (sorted by name) how I would like to see Meridian sort these files names.
-
Kevin P
- Aug 12 2020
- Future consideration
Since The versioning revision number shown in the ticket is a concatenation of two properties called MajRev and MinRev and both are string fields and further resulting in the string field . Hence following the sequence of 1, 10,11......19 before 2 upon sorting
can you adjust the file sorting result to print 0 before the number?
01,02,09,010
020, 021
Yes, Windows Explorer uses StrCmpLogicalW API
https://docs.microsoft.com/en-us/windows/win32/api/shlwapi/nf-shlwapi-strcmplogicalw?redirectedfrom=MSDN
Please consider using this. Our documents are sorted by drawing numbers, e.g. AE-1, AE-2 etc. and I can't imagine that this is an unusual way to sort documents in this software. It's current lexicographical sort method is a mess to scroll through - (see attached example)
Need to research this. We are currently using a Windows API to sort strings, but Windows Explorer apparently uses another API or method.