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
  • Attach files
      Drop here to upload
    • Guest commented
      January 25, 2023 20:17

      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


    • Brian Bailey commented
      April 19, 2021 18:15

      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)



    • Admin
      Rudi Pieters commented
      September 02, 2020 06:46

      Need to research this. We are currently using a Windows API to sort strings, but Windows Explorer apparently uses another API or method.