Questions tagged [sorting]

Sorting is any process of arranging items according to a certain sequence or into different sets.

Filter by
Sorted by
Tagged with
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 ...
okoolo's user avatar
  • 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 ...
Kalamalka Kid's user avatar
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 "&...
Zolboo B's user avatar
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 &...
robertspierre's user avatar
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 ...
M Hurley's user avatar
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 ...
elucid8's user avatar
  • 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, ...
DanPCrz's user avatar
  • 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 ...
NewSites's user avatar
  • 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 ...
sylverone's user avatar
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 ...
Chris Bedford's user avatar
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 ...
user avatar
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 ...
Arj's user avatar
  • 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 ...
einpoklum's user avatar
  • 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 ...
Marina Michaels's user avatar
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): ...
Brian's user avatar
  • 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 ...
Dr_Xunil's user avatar
  • 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 ...
Lexible's user avatar
  • 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 -...
over-heaven's user avatar
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....
Lu Venary's user avatar
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 ...
Bra Tabs's user avatar
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?
user15555955's user avatar
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. ...
Blastcore's user avatar
  • 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 ...
siryx's user avatar
  • 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 ...
hide2may's user avatar
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 ...
Sean P Sullivan's user avatar
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 ...
Saher Naji's user avatar
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 ...
Antóin's user avatar
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 ...
KevInSol's user avatar
  • 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 ...
Saher Naji's user avatar
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(), ...
Dominique's user avatar
  • 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 ...
S G's user avatar
  • 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 ...
Mark's user avatar
  • 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 ...
BmyGuest's user avatar
  • 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 ...
Nys's user avatar
  • 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:...
FluidMechanics Potential Flows's user avatar
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 ...
robgaillard27's user avatar
1 vote
1 answer
49 views

Sort slicers data in excel

how can I sort data in slicers as shown in this photo
Mehmed Odeh's user avatar
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 ...
user697473's user avatar
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; ...
Christopher King's user avatar
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 ...
essay's user avatar
  • 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 ...
AyaanMAG's user avatar
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 ...
amymor's user avatar
  • 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 ...
RocketNuts's user avatar
  • 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 ...
user1530279's user avatar
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....
ph3ro's user avatar
  • 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 ...
Harley Frey's user avatar
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 ...
austin yarnell's user avatar
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 ...
alex's user avatar
  • 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 ...
Stacy's user avatar
  • 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?
Udesh's user avatar
  • 852

1
2 3 4 5
15