Questions tagged [sorting]
Sorting is any process of arranging items according to a certain sequence or into different sets.
723
questions
1
vote
2
answers
285
views
How may I sort strings with more than one pre-requirement?
I have bunch of strings (around ~300) and they are all 4 letter such as
XYZA, ZHF3, RTt2 etc. I want to sort them depending on the 2 requirement.
Sort them in order of last 2 letters
Sort the words ...
- 74.3k
7
votes
2
answers
1k
views
In which order does Windows Explorer sort folders when sorting the results of the search by size?
The files are sorted by size but not the folders, so I wonder how Windows Explorer decides the ordering of folders when displaying them. I use Windows 7 SP1 x64 Ultimate.
Example of sort by size:
- 9,630
3
votes
1
answer
7k
views
Sort by number at the end of the file name in Windows Explorer
I want to know how can I sort my files in Windows Explorer using the last two digits in the file name. I have the following files in my folder:
f00001.jpg
f00002.jpg
f00003.jpg
b00001.jpg
b00002.jpg
...
0
votes
2
answers
2k
views
sorting dates and time (in text form) in Excel
My date and time entries in my excel file are written in the form of: Feb 18 at 3:50pm. All of this is in one cell. I was wondering if there is a way to sort this out (arrange chronologically)
- 1,030
-1
votes
2
answers
122
views
Sort by 2 different conditions windows detail view
Is it possible to sort by both name and date in windows detail view?
First sort by name so that I can see the range of product I want and then by date in order to get the latest version of the product?...
- 9,630
0
votes
0
answers
25
views
Ordering files alphabetically is not respected in Windows Explorer [duplicate]
I've a folder with a file list.
All files have the same root name but change in order on its refere date, as follow:
This is my wished alfabetically order:
MyName - 202003.pdf
MyName - 202006.pdf
...
- 8,981
0
votes
1
answer
84
views
How to sort network devices with VLANs by numeric order
I'm trying to create a neat and tidy motd for some embedded devices that will have multiple NICs and VLANs.
Here's a sample output:
Networking sent recv tx-err rx-err address
enp7s0 UP 66K ...
- 454k
2
votes
1
answer
609
views
Sort and change index numbers in Notepad++
I have some files that start with an index number similar to this:
(1) etc
(2) etc
(3) etc
I want to add lines between and make Notepad++ to change index numbers automatically. So for example if I ...
- 17.9k
20
votes
4
answers
35k
views
Sorting Excel column by IP address
I have a fairly large (over 200 row) Excel spreadsheet that lists items in my network (i.e. printers, servers, workstations, network projectors, etc), and one of the first columns is the IP Address ...
- 301
1
vote
1
answer
448
views
Counting and sorting a cell in excel
I need help to sort out a list of agencies. I have now gotten the frequency for each agency but I need them to match.
Then, I need to sort out this list from Largest to Smallest frequency. That means ...
1
vote
1
answer
198
views
Win 10 Libraries option "Arrange by" won't display pictures from previous years?
It's simple as the title. On Windows 10, when I go to "Libraries", then to "Pictures" I can see folders that I included in a Library. When I open the folder, all the pictures are ...
- 29.7k
0
votes
1
answer
1k
views
How to group multiple date|data columns to one single date column on the left?
I've got a large set of data that looks like:
and I've been trying to format it so that instead of having a column of dates for each item, there's only one column of dates on the left. The problem is ...
- 8,748
2
votes
2
answers
1k
views
Advanced sorting of alphanumeric data
I need to sort data that takes on the format: A1, A2...A10...A?? then starts at B1, B2...B?? and once it gets to Z?? goes to AA1, AA2, AA3...AA?? and then to AB1, AB2, and so on. I never know how ...
- 17k
2
votes
1
answer
115
views
merging files in numerical order ubuntu
Hy everyone!
I have a list of 100 numerical files 1.txt 2.txt...n.txt
I want to merge their content to an output.txt , but would like to keep their numerical order, such as my output file would ...
- 296
2
votes
1
answer
68
views
Count based on unique subset of fields
I have a text file that is structured as follows:
P,ABC,DEF
P,GHI,JKL
B,ABC,DEF
B,MNO,PQR
I want to get a count of how many times a line appears where fields 2 and 3 are the same while preserving ...
- 74.3k
18
votes
2
answers
10k
views
Sort --parallel isn't parallelizing
I'm trying to make unique a set of lines pulled from a file with egrep with sort -u, then count them. About 10% of the lines(all 100 characters long from the alphabet [ATCG]) are duplicated. There are ...
- 4,809
0
votes
1
answer
11k
views
How to keep references unchanged after sorting
In the following spreadsheet, the references will change after sorting and break the calculations.
Absolute referencing is not an option. The table has to be copied periodically to another sheet and ...
0
votes
1
answer
56
views
Sorting and ordering two expense lists by a third list of categories using Excel 2016
I want to use Excel 2016 to sort two expense lists by a third list of categories.
The first catch is that I want to place the value in the same cell like the categoris list – It's not a simple sort, ...
- 18.7k
0
votes
0
answers
29
views
Sort Value & Description Together Horizontally
I have a set of data listed horizontally where two cells work together with the value and description.
A1 B1 C1 D1 E1 F1
300 Description3 100 Description1 200 ...
- 13
8
votes
1
answer
7k
views
Sort lexicographically in bash
I want data to be sorted in the way Python sorts it, comparing ASCII values. But sort command seems too clever for that. Take a look. Since '.' < '9':
$ sort
.
9
^D
.
9
and :
$ sort
1.
19
^D
1.
19
...
- 13
0
votes
2
answers
2k
views
In bash, how can I replace empty lines with null and vice-versa?
How can I replace two newline characters \n\n with a null \0 character in bash, and vice-versa?
I see that td can replace a single newline with null, but not two consecutive newline characters. I ...
- 188
0
votes
2
answers
641
views
Blank cells outside of Excel sort selection affecting sort order
I'm struggling to correct an issue in a data set where I am trying to sort rows by two different columns, but some rows contain a blank cell. I am sorting by State and then by Company; however, it ...
- 1
2
votes
1
answer
360
views
Within a category, how can I get the apps in Xfce 4.14's Whisker Menu to sort alphabetically?
Whenever I install a new program and it gets placed in a category on the Whisker Menu (e.g. "Education", "Development"), it always defaults to putting the program at the bottom of ...
7
votes
3
answers
33k
views
Sort order "Other Calendars" in Outlook
If I open a Shared Calendar in Outlook, it will be added in the "Other Calendars" section. Unfortunately Outlook doesn't sort them by Name. Is there a way/hack to sort them alphabetically?
0
votes
1
answer
129
views
need to sort a table so the whole table is sorted not just one column
how to I sort a table so the whole table is sorted. Imagine I have 10x10 table with numbers 1-100 that are placed randomly in the table. I want the table sorted so the first column has 1-10 then the ...
- 8,748
0
votes
0
answers
54
views
How do I sort folders by comment in Mac using AppleScripts?
I have folders in this order:
content
forms
gallery
header
misc
navigation
slider
title
I want to sort them this way:
navigation
header
content
title
gallery
slider
forms
misc
I have seen ...
- 19
3
votes
1
answer
905
views
Sort with case-sensitivity in macOS in the Terminal
I am trying to use the answer in GNU Sort by case-sensitive to sort a file in my Mac OS.
My file.txt looks like this:
"Best"
"A"
"BEST"
In the second answer to the mentioned question, it says that ...
- 477
2
votes
1
answer
300
views
Does sort (Unix) work on hexadecimal input?
I have a file where each line is a number printed in hexadecimal, for example a0
Can I sort it with sort -n or does it have to be in base 10 ?
- 70.7k
1
vote
1
answer
218
views
WinSCP folder sorting
How can I "sort" folders in WinSCP?
For now it looks like this:
but I want folders to be on bottom.
- 19
0
votes
1
answer
60
views
Advanced sorting in Excel partially alphabetical (grouped)
I need to sort some text cells, but it's not (entirely) alphabetical.
It should be alphabetical, but grouped. So first all the non 45 or 90 degrees then the 45 and then the 90.
Some background info:
...
- 9,224
2
votes
3
answers
1k
views
Sort Large amount of files into equally sized folders (windows)
I have about 15000 zip files with a total size of just over 10 gb that need to be sorted into folders that should not exceed 200 mb.
(none of the files are larger than 40 mb and most of them sub 1mb)
...
- 8,243
3
votes
1
answer
10k
views
Alternate Row Colors of Duplicate Data in Excel
I am working with a dataset in Excel that contains duplicate values and non-duplicate values that are numbers. I would like each duplicate value group to have alternating shades via Conditional ...
- 1
0
votes
1
answer
495
views
Using NPP, is there a method to numerically sort values separated by commas (single column)?
I have a large JSON csv file of values (one column). In order to remove duplicates, I need to first Replace All CRs then use TextFX Sort Lines function, then Replace All the CRs with commas (such that ...
- 31
2
votes
1
answer
934
views
Windows alphabetical file sorting: is there a way to ignore extensions?
(This is a follow-up to Windows alphabetical file sorting: why do spaces have special treatment?)
For years I have been confused by the Windows file sorting order; as an example, the pdf file named &...
- 342
0
votes
0
answers
109
views
Same Icon on a folder and its nested sub folder in Windows 7
Does Window 7 provide such a feature where the same Icon can be applied to folders nested folders? Even if a new folder is created it should have the same folder.
The images are shown of all folders, ...
- 191
119
votes
12
answers
118k
views
How to sort first directories then files etc… when using “ls” in Unix
I would like to use the ls command to first show directories and then files. I tried:
ls -la | sort -k 1
But I got a wrong order.
- 421
0
votes
1
answer
777
views
Sort by Type → folder and all its sub folder
Below is a GIF that shows sort by type on a subfolder of the main folder. The main folder has many subfolders and deeper layers can the sort by type be applied in one go on the entire folder and its ...
- 943
1
vote
1
answer
152
views
Using excel to organize an alphanumeric list
How do I get the following list in order alphabetically, and then by numerical values on an excel sheet? CV1, CV2, CX1, CX10, CX2, CX3, CX20, CX4, CX30.
Final order should be: CV1, CV2, CX1, CX2, CX3, ...
- 68
1
vote
2
answers
4k
views
How do I sort files by date in filename?
I have a set of filenames like this
vorlesung 02.11.15.mp4
vorlesung 04.01.16.mp4
vorlesung 07.12.15.mp4
vorlesung 09.11.15.mp4
vorlesung 09.12.15.mp4
...
The last part of the file name is a date in ...
- 2,595
0
votes
0
answers
860
views
Folder takes a long time to sort by date modified every time
I have a screenshots folder that is sorted by date modified. Every time I open up this folder to retrieve a recent screenshot, it takes 5-10 seconds to sort it. Is there a way to make this ...
- 833
0
votes
1
answer
230
views
Excel 365: How to extract data from one sheet and automatically sort it WITH DUPLICATES
I have a small gaming table, of about 100 entries, with constant data updates.
Sheet: Officers
Name | Def | HP |
-----------------------
John | 10 | 50 |
-----------------------
Doe ...
- 18.7k
0
votes
2
answers
247
views
How do I rank values based on a criteria
I have survey data for 3619 individuals living in 1000 houses. The MID column is the member ID of each individual. For example: H1M1 is 1st Member of 1st House. H21M3 is 3rd member of 21st house. ...
- 8,748
1
vote
1
answer
4k
views
Warning when Excel is not sorting adjacent columns
I run into a repeated problem when using Excel, which happens in two steps.
I select all my data columns, and click the "Filter" button on the Data tab to enable filtering. Then I use the arrows at ...
- 1
2
votes
3
answers
1k
views
Does excel provide a method for sorting columns based on numbers and phrases contained within one cell?
I receive a packet of data in the form of a .csv file from our database manager. I import this data into excel for formatting and sorting. However, one column contains three pieces of info that I want ...
- 6,840
0
votes
2
answers
35
views
How to number the data based 2 set of rules (Date and Type)?
I am creating a database where different numbers will be assigned to each row based on 2 parameters.
Date
Manager Name
As shown in the image based on the consultant and the date of booking, the ...
- 8,748
0
votes
1
answer
915
views
one-liner to put two commands on same line, from the multiline output of `find... | sort... | cut ...`
This is a continuation of recursively sort files with string "SENT_" somewhere in filename by the substring immediately after SENT_, and then display them. Linux as I thought it was better ...
- 511
0
votes
1
answer
196
views
How to sort Excel data on multiple columns
I would like to have an Ascending sort on a column, but subsetted based on the value in another column. So for example, in column A I have 25 rows equal to 1, followed by 25 rows, equal to 2, followed ...
- 6,840
1
vote
1
answer
1k
views
How to sort a row of text in Notepad++
So I have about 100 - 200 words in one single row, in a *.config file that I need to sort in alphabetical order.
I've seen many posts of how to do so if the text is in lines but not if it is all in ...
- 17.9k
0
votes
2
answers
828
views
Compare framewidth and frameheight in Windows explorer search
I am trying to sort a large group of videos (1700). I want to separate videos that have a width that is bigger than the height from videos that have a height bigger than the width.
I found online the ...
- 1,180
-1
votes
2
answers
71
views
How To Sort Time Data, to only showing exact clock (hh/mm/ss)? [closed]
i want to sort my time data (there's a lot of it), to only showing data that only show the exact clock in hh/mm/ss format, so i can delete the unnecessary data.
for example,
from :
to only showing ...
- 18.7k