Questions tagged [sorting]
Sorting is any process of arranging items according to a certain sequence or into different sets.
714
questions
0
votes
1
answer
28
views
bash sort by numeric substring
In bash shell I'm trying to sort by a numeric value at the end of each line (sort by number of packets)
Tried to use "sort -k6 -t '=' -n but not working.
Input:
type udp ip src=192.168.2.173 ...
- 15
2
votes
2
answers
44
views
Sorting files and folders by hexadecimal and decimal values
A while a go I needed to figure out how to sort my files by hexadecimal order. I found some very useful information in this awesome answer:
Adding "NoStrCmpLogical" as DWORD with a value of ...
- 2,491
1
vote
1
answer
44
views
How to Sort and Move Files Based on their Extensions on Windows
I'm trying to sort and move files based on their extensions within Windows, and am following this tutorial using:
@echo off
for %%a in (".\*") do (
if "%%~xa" NEQ "&...
- 17
0
votes
1
answer
43
views
What are version and revision of a file?
The docs for the nnn file manager says that nnn is able to sort a list of files on the basis of:
apparent disk usage / disk usage / extension / revision / size / time / version
But what are the &...
- 289
0
votes
1
answer
23
views
Outlook Online: I can’t seem to filter according to sender
Outlook Online: I can’t seem to filter according to sender!
I am working with Outlook online, chrome browser, from a desktop—not a phone app / Mac OS.) I did check some community answers, But I didn’t ...
- 1
1
vote
1
answer
36
views
Difficulty performing complex sorting when listing files in a directory with the ls command
The behavior I'm seeking is a nested sort with the ls command where sorting by one method doesn't cancel out sorting by a second method. The exact desired behavior is essentially:
First sort with ...
- 68
1
vote
1
answer
54
views
How can I arrange arbitrarily folders in Windows 10?
I want to sort some music folders by the release date, so I was wondering if there's a way to edit the metadata of the folder, because looking on the sort options, there's a "year" column, ...
- 13
0
votes
0
answers
24
views
MS Access table not sorting by primary key
Environment: MS Office LTSC Pro Plus 2021 under Windows 11 Pro 64.
I have an Access table with 300,000 records and 28 fields, including an autonumber primary key. Yesterday, after adding the 28th ...
- 610
3
votes
1
answer
102
views
How can I make new subfolders created in a directory inherit the parent folder's sort type as default (such as "date modified")?
So I have a folder within which new folders containing images are frequently created. These images are frequently updated, and I prefer to set them to sort by "date modified" so the most ...
- 61
1
vote
1
answer
127
views
Editing rules in Outlook 365
I have a list of 30 rules to sort incoming mail on my POP3 and IMAP accounts, and move them into relevant folders (or permanently delete the known spammers).
Such a large set of rules didn't happen ...
0
votes
0
answers
165
views
Excel: How to best sort/match two (+) columns with a different amount of rows?
Hello I am trying to figure out a few different ways to accomplish this, to find the most efficient approach. Any and all help appreciated.
Here is one workaround I found but cum er some and does not ...
jds00
0
votes
0
answers
25
views
Sort information in Excel displayed in "cards" [duplicate]
I'm looking to create data "cards" in Excel which is a way to visually display information next to an image:
The reason to display information this way is because I want to always be able ...
- 103
0
votes
0
answers
410
views
In an Excel PivotTable, how can I sort by multiple row fields?
In Excel PivotTables, it's easy to sort, say, the rows by the major row field: There's a "Row Labels" column with a menubutton on the side, you click it, and you get sort options, just like ...
- 8,824
0
votes
0
answers
32
views
Sort text and numbers in Excel so the numbers sort properly?
I've created an inventory of my watercolor paints. Paints use pigment categories and pigment numbers. For example, blue pigments all start with the pigment category PB (pigment blue), followed by the ...
0
votes
1
answer
174
views
Powershell: sorting directories based on file count
I am attempting to create a list that counts the number of files in a folder and then sorts the order of the folders based on that count. I have the following but it doesn't work (i.e. doesn't sort):
...
- 977
0
votes
1
answer
158
views
Column sort is not putting numbers in the correct order
I am uploading a .csv file into a third-party program with the following data for example:
When the (third party) program sorts this data by the 'Number' column it looks like it is sorting the column ...
- 326
1
vote
0
answers
41
views
Alpine email client does not sort alphabetically
How can I get the Alpine email client to correctly sort From? I am using Alpine v2.21 on Ubuntu 18.04 LTS server. When I attempt to do so for a folder, I typically get garbage like (I have redacted ...
- 452
0
votes
0
answers
17
views
How to Globally ( permanently ) add option to sort by date downloaded [duplicate]
I am looking for answers to two questions:
What's name of sorting method that sorts by Date Added To Library?
How do I make that sorting style appear as default on my Windows 10 right-click Sort By -...
1
vote
2
answers
269
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....
- 11
0
votes
2
answers
669
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 ...
- 1
0
votes
0
answers
73
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?
0
votes
0
answers
77
views
Apply sorting to multiple folders in Explorer
Right now if I open a folder with pictures on Windows Explorer, I can apply the sorting I need on it for example by Date or by Name, Ascending and Descending. That setting applies only to said folder. ...
- 213
1
vote
2
answers
539
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 ...
- 25
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
1
vote
0
answers
74
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
86
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 ...
- 45
0
votes
0
answers
90
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 ...
- 1
0
votes
1
answer
651
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 ...
- 103
1
vote
1
answer
87
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
...
- 45
0
votes
1
answer
339
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(), ...
- 2,015
0
votes
1
answer
345
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 ...
- 3
0
votes
1
answer
359
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
1
vote
1
answer
64
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 ...
- 406
1
vote
0
answers
238
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 ...
- 11
0
votes
2
answers
810
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
246
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
49
views
0
votes
2
answers
843
views
Group Outlook tasks by due-date categories: "Today," "Tomorrow," "This Week," "Next Week," etc
I use Outlook's Task "peek" to organize my to-do list. When I let Outlook "Automatically group [tasks] according to arrangement," as in this picture—
—it groups them by the ...
- 131
0
votes
1
answer
454
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; ...
- 115
0
votes
1
answer
22
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 ...
- 103
0
votes
2
answers
504
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 ...
- 11
0
votes
0
answers
43
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 ...
- 35
1
vote
2
answers
225
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 ...
- 1,052
0
votes
0
answers
1k
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 ...
- 39
0
votes
1
answer
34
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....
- 143
0
votes
2
answers
1k
views
Windows Powershell: Get Items from directory -> md5 them -> sort list by filename -> out to file
Is there the way to complete mimic this unux command entirely by Windows Poweshell means, not with using the WSL:
find ./<dir1>/ -type f -exec md5sum {} + | sort -k 2 > dir1_hashes.md
I ...
0
votes
1
answer
234
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
284
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 ...
- 123
0
votes
2
answers
105
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 ...
- 1
0
votes
1
answer
767
views
How to sort output of top command based on nice value?
We can use Shift+p to sort on basic of cpu usage, Shift+r to sort on basis of pid & Shift+m on basis of memory utilisation.
How to sort output of top command based on nice value?
- 852