Questions tagged [sorting]
Sorting is any process of arranging items according to a certain sequence or into different sets.
722
questions
0
votes
2
answers
845
views
How to modify search order for ALL folders
what I mean by this is when you right-click in a folder, there is an option "More" By default, the only time-based sorting is Date Modified which takes very long, sometimes half a minute and ...
3
votes
3
answers
4k
views
How to sort files in exFAT drive alphabetically?
I have an MP3 player that uses a micro SD card as storage. The SD card is formatted in exFAT. When I browse files in the MP3 by folder location, the order of album tracks is not in alphabetical order ...
0
votes
2
answers
2k
views
Need Windows script to create folders named with file dates and move files to the matching folder
I need a CMD or Powershell script or batch file to
step through a list of files
make a folder named with the date of a file if it doesn't already exist, then
move that file into its matching ...
0
votes
2
answers
4k
views
Change the "modified date" of a folders (in possibly powershell)
From time to time, when I force-shutdown a Windows Server 2003 machine (I have no choice), the folders contained in a certain directory all change their 'modified date' to the current date.
Luckily, ...
1
vote
2
answers
476
views
How to sort folders by icons, rather by name of folder?
I created icons that are labelled with numbers, but I would like to name them not by the associated number.
It creates a problem because the icons will be alphabetically sorted and in thus in disorder....
0
votes
2
answers
1k
views
Powershell script Select sort output by number
The following powershell script outputs a server diskspace report.
Is there a way of sorting the 'Percent' data in either desc or asc order?
[Script]
$computers | ForEach {
$Disks = Get-WMIObject ...
3
votes
1
answer
2k
views
File Sorting in HEX on Windows?
How can I sort file names by HEX instead of whatever Windows 10 does to sort files?
I have a huge list of sound effect files in a folder and because of how Windows has no option (from what I can see) ...
0
votes
0
answers
128
views
What order are wifi-networks displayed in windows?
When you open the wifi menu on Windows, the order of the networks seems random. What order are they meant to be in?
1
vote
2
answers
977
views
Correctly sort semantic version list using Excel
We use Excel to export summaries/ticket lists from our bug tracker. The column I would like to sort by is the "version" column. We use semantic versioning (https://semver.org) because of ...
0
votes
2
answers
25
views
Sort out whose who are still working by date
I have an Excel file with 4 columns: Name, Staff_No, Date_Joined, Date_Left.
My boss wants to know those who are still working.
The output should look: Name, Staff_No, Date_Joined.
Any idea for the ...
1
vote
0
answers
258
views
Mac is not sorting by filename correctly (Not a Group By or Arrange By issue)
I've noticed a strange sorting issue on my Mac OS in Finder. I have image files with the following format:
PROJ-202301-General-{random 5 char string}0{maker name}{datetime stamp}{title}.jpg
I have ...
0
votes
1
answer
168
views
Keep VBA code working if I run it from a button in another sheet, or replace the code with formula
I'm trying to sort the date in an excel sheet, I want to click on a button to do this, but button is not at the same sheet
I assigned the macro in a button in the same sheet, it worked very well, but ...
1
vote
2
answers
2k
views
Thunderbird thread view - sort by star then date
So far I've been sorting my emails in non-threaded view, by star, then by date. Understand, first all starred message (sorted by date) then non-starred message (also sorted by date)
Either this doesn'...
0
votes
1
answer
173
views
Sorting lines according a column value
I need to sort all of the linnes in the csv filles according to the number contained in the second column from min to max, ignoring the first (header line):
ID(Prot), ID(lig), ID(cluster), dG(...
0
votes
0
answers
153
views
Extract files in order by numbers at end of filename (windows)
I want to use a Windows .bat file to extract a number of files in a folder.
I have files with numbers at the end of filename, just before the extension, and I need to extract them in order of these ...
0
votes
1
answer
884
views
Windows 11 File Explorer file name sort order - getting a file to the top
I'm creating an archive of a web site and within each directory (folder) I have a file called !THE_PAGE_TEXT.html which is basically a readme file for that directory's contents.
I want that to appear ...
1
vote
1
answer
110
views
Making the VBA code affect a specific range of pages
I have this very simple code
Sub SortByTime()
'
' SortByTime Macro
' Sort by Time
'
' Keyboard Shortcut: Ctrl+Shift+M
'
Range("C4:J43").Select
ActiveWindow.SmallScroll Down:=-36
...
1
vote
2
answers
4k
views
How to sort files in Windows explorer in custom order?
I have a great deal of folders. Each contains more than 30 files. I’d like to sort these files in a custom order. How do I create a custom order and have it sorted out the files the way I want?
I was ...
23
votes
4
answers
34k
views
Is there a Windows equivalent to the Unix uniq?
I need remove duplicate lines from a text file, it is simple in Linux using
cat file.txt |sort | uniq
when file.txt contains
aaa
bbb
aaa
ccc
It will output
aaa
bbb
ccc
Is there a Windows ...
0
votes
1
answer
619
views
UNIX or Linux sort: only sort on the first part of an entry
I'm working on a complicated grep, something like grep -E -i "first|next" *.txt, and I get results like:
logs.10.txt:2022-10-07 10:33:05.6673 | ClassName | [Info] | Inside function first(), ...
0
votes
1
answer
789
views
Windows-11 File Sort Command to view all files within subfolders
I used to use a sort command when trying to view all files across a bunch of folders at once. It makes sorting files easier. I do know part of the command was written as not sort kind, I may even have ...
0
votes
1
answer
554
views
How do I fix a sorting issue not related to numerical sorting in Windows File Explorer?
I'm familiar with numerical sorting where the issue is a number as a value or a string. I'm asking a different question.
I'd like to sort files in a way such that the file that includes a string after ...
1
vote
1
answer
97
views
How can I best reorder data in mixed row/column format into a simple table?
I have (from a CVS file) data in the following format:
The data is a continued list (row by row of comma separated values) where in arbitrary locations columns are inserted or removed. At these ...
14
votes
4
answers
42k
views
Alphanumeric sorting in Excel
In Excel, is it possible to sort alphanumerics from a-1, a-2, a-3...a-123 instead of a-1, a-10, a-100, a-11?
Sorting via oldest to newest or via A-Z, definitely won't give me the result I want. I've ...
1
vote
0
answers
633
views
Sort files manually
I've got one simple problem (and expected one simple solution, which I didn't find).
I would like to sort files manually (drag and drop) on Windows 10.
I've read a lot of workarounds (e. g. renaming ...
1
vote
2
answers
2k
views
Sort column by first two letters
I would like to sort a column but only based on the two first letters. When the two first letters are the same, I would like to sort on another column.
This stackoverflow answer mentions this solution:...
0
votes
1
answer
298
views
Linux shell - Sort on a numerical column
I'm using the linux shell in a jupyter notebook. I'm trying to filter rows of a .csv file to only keep those including 'Government expenditure on education, total (% of GDP)', then to only keep ...
1
vote
1
answer
68
views
Sort slicers data in excel
how can I sort data in slicers as shown in this photo
0
votes
1
answer
686
views
Why do these sort in different order?
I expect 01 to appear first or last in both of these sorts but actually changing the length of the second record changes the sort order. Why?
$ { echo 01; echo 0_12; } | sort
01
0_12
$ { echo 01; ...
0
votes
1
answer
27
views
Sorting in excel with additional conditions
I have several rows of objects, each row with a specific date.
Currently, the spreadsheet is ordering the rows by date increasing, using the ROW function.
However, I need to introduce a new ordering ...
4
votes
2
answers
6k
views
Are there special characters that can be used for sorting but not displaying?
We have a short simple list of text strings on a platform that forces alphabetical order. We'd like to have a custom order without prefixing numbers or other distracting characters (it's a customer-...
4
votes
1
answer
552
views
How to separately sort lines within multiple "chunks" separated with headers?
This question is complementary to this one: Sort packs of lines alphabetically. After answering there, it turned out I had totally misunderstood the question and solved another problem. Not wanting my ...
0
votes
0
answers
79
views
Different sorting by name in Windows Explorer and other Apps
i noticed Windows Explorer and many apps like Winrar sort folders by name like this order:
(test
)test
.test
@test
_test
+test
0test
1test
atest
-atest
but in some other apps like 7z and unlocker, i ...
1
vote
2
answers
427
views
Excel / LibreOffice Calc: find item in column with latest first occurrence?
In a Calc or Excel sheet I have a column with bunch of names. Each name can occur one or multiple times.
Each name has a 'first occurrence' i.e. the first row in which it appears.
I'm looking for an ...
0
votes
0
answers
2k
views
How to sort dates in ascending order in pivot table by month
I am trying to get a pivot table data set to sort dates in ascending order. The first step I took was to ensure the year was populated first. So, this is sorted by the year. However, the months are ...
0
votes
1
answer
47
views
Sorting the list of subnets as Integers ascending
I have a list of subnets for eg.
180.151.96.0/22
180.151.240.0/21
119.82.112.0/22
203.122.29.0/24
203.122.48.0/22
119.82.92.0/24
180.151.108.0/23
119.82.124.0/24
119.82.89.0/24
180.151.17.0/24
119.82....
0
votes
1
answer
413
views
Keeping two rows together when sorting
I would like to know how to link specific rows when sorting a table in excel. I have already made the table and in each row contains data for a specific person. Each person has two rows. My boss would ...
1
vote
1
answer
415
views
Windows 10 - Sort option acts differently between two folders
I have a folder where, when I sort my files by date modified descending, all the subfolders are at the bottom. Then, in another folder, it is also sorted by date modified descending, yet the ...
0
votes
2
answers
144
views
Multi-level sorting in Excel
I have to run a report that has the data shown in the pictures. I need to sort it only by the R-A** (release) in column c then sort each release by assembly (column b). I can't sort it that way ...
0
votes
1
answer
613
views
Excel custom sort list works in Excel but not when file is transferred to SharePoint
I created a custom sort list of fiscal weeks that I use for my reports in Excel. For many reports I also use them as a Slicer. I have come across the issue where this custom sort list works perfectly ...
11
votes
2
answers
8k
views
Windows 10: Sort/rearrange icons in taskbar
I was wondering if there is an option in Windows, a tweak or third party software to allow arranging icons in the taskbar (currently it is possible only to drag a group of the same program, but not an ...
5
votes
3
answers
44k
views
How to order a numbered list in descending order?
When using a numbered list in Word, how can I have it order in descending order (ie. 10., 9., 8., 7., ...) ?
0
votes
0
answers
35
views
Custom excel sort/order?
So I've gone through a whole lot of sorting which isn't relevant to the question,
but for elaboration I'm getting 10 results out of 14. These results will be in order from 1-14 as I get them through ...
0
votes
1
answer
581
views
Which file system sort order is fastest in Windows 10 for large libraries?
Which file system sort order is fastest to load in Windows 10 for large libraries?
My intuition always told me that sorting by date modified was the fastest one to load up.
0
votes
1
answer
4k
views
Pivot Table: Sort row by hidden field
I have a table in Excel 2016 (source: Microsoft Query/ODBC):
Raw data:
Construction Type Location Sort
Reconstruction Main St - Red St to Blue St 1
...
0
votes
1
answer
2k
views
Linux `sort` doesn't work on numeric field
Here is a sample text file:
Peter:123777:ETA
Joan:16466:HLT
John:11223:HR
David:23456::::FSI
George::::876543:ECS
The task is to sort on second field, so I did the below:
cat input.txt | tr -...
1
vote
1
answer
553
views
Sort lines with "natural order" in Notepad++ like Windows Explorer?
Q: Is it possible to sort line with "natural order" (or what it calls, I'm not sure the correct name) like/similar to Windows Explorer? With or without plugin are fine
Demo lines:
text 1
...
0
votes
2
answers
525
views
Sorting Excel tables by localized alphabetical order
The English Excel (improperly) sorts the following strings as follows:
SARKIN
ŞENER
SEZER
ŞİMŞEK
SÜRMELİ
However, these are all Turkish strings where S and Ş are strictly different letters and Ş ...
0
votes
2
answers
1k
views
Excel Sort Command not working AT ALL as expected
I have a table in excel (formatted as a Table), that does allow me to sort, but its results are incorrect in at least two ways:
the numeric value column I am sorting on A-Z or Highest-to-lowest comes ...
0
votes
1
answer
19
views
Automatically send certain filetypes to preset location
So the workflow I'm going for is saving the active webpage as .MHTML using a keystroke and make it go into a pre-set save location, so there's no interruption to browsing. I can easily get the .MHTML ...