Jul 30 2019 07:19 AM - edited Jul 30 2019 07:20 AM
10 is a bigger number than 9, when sorting files by Name 10 should come after 9...
Jul 30 2019 12:19 PM
SolutionJul 30 2019 12:24 PM
Jul 30 2019 12:29 PM
Jul 30 2019 12:29 PM
@Chris Webb I figured this was the case... on-par with with Microsoft's user experience across their multiple applications...
@adam deltinger Sharepoint access is already available
Jul 30 2019 12:31 PM
Nov 08 2019 07:41 AM
@HYPERVELOCITY The sorting is character by character, so it compares "9" to "1", not "10", because the nine and the one are in the same position within the name. If you put a zero in front of the nine, such as "09" it will sort how you want because the zero will be compared to the one.
Here is an example of how the sorting works:
fileName01.txt
fileName05.txt
fileName07.txt
fileName09.txt
fileName1.txt
fileName10.txt
fileName27.txt
fileName3.txt
fileName50.txt
fileName8.txt
fileName9.txt
For each additional digit in your number length, you would need to pad with another zero.
Nov 26 2019 05:50 AM
Nov 26 2019 05:59 AM
Dec 13 2019 12:28 AM
Use the correct number format for sorting … 01; 02; 03; … ; 99 or 001; 002; … ; 999
Jul 30 2019 12:19 PM
Solution