Forum Discussion
Drive1000
Oct 01, 2021Copper Contributor
Sort by Name not proper for numbered files.
Just trying to understand the logic of OneDrive's "Sort by Name" when it comes to numbers. Take a look at the below. "9-26" shouldn't be coming before "9-3". The number 26 should be perceived as afte...
- Oct 01, 2021It’s by design. In order to fix it you have to put always ensure your number have 2 digits.
Ex. 2021-9-4 should be 2021-09-04 and then your file will have the proper order.
jab365cloud
Steel Contributor
It’s by design. In order to fix it you have to put always ensure your number have 2 digits.
Ex. 2021-9-4 should be 2021-09-04 and then your file will have the proper order.
Ex. 2021-9-4 should be 2021-09-04 and then your file will have the proper order.
Drive1000
Oct 01, 2021Copper Contributor
Thank you, I did consider that but I have thousands of files and will need to figure out a command line to change them all with variables involved. I thought I had resolved it at first with sorting by file creation date but that is not always accurate to the file contents, hence the name scheme.
Hopefully this is something the devs can reconsider.
Hopefully this is something the devs can reconsider.
- Mike WilliamsOct 02, 2021Steel Contributor
Drive1000 In your example, it's not necessarily clear that these are dates. Credit cards and other codes have a similar format numeric dashed format. To sort as you desire, use ISO 8601 date formatting with 2 digit months for unambiguous representation as recommended by most data management authorities.