Questions tagged [sorting]
Sorting is any process of arranging items according to a certain sequence or into different sets.
635
questions
0
votes
0answers
8 views
Trying to summarise multiple lines of data by latest date (LinkedIN Export)
I want to create a list which shows the latest date that someone sent me a message on Linked In. I have exported the data, in the following format, and there are multiple entries for individuals who ...
0
votes
1answer
20 views
In LibreOffice Calc, why would sort buttons and menu items suddenly become disabled?
I was creating a spreadsheet in LibreOffice Calc. Several times, I used the "Sort Ascending" and "Sort Descending" toolbar buttons. All was well, and everything was working as ...
asked Apr 19 at 11:17
RockPaperLz- Mask it or Casket
6,28519 gold badges58 silver badges99 bronze badges
1
vote
1answer
46 views
What does # mean in Windows Explorer column?
What does # mean in the Windows Explorer column?
I've never seen something written in that column.
0
votes
1answer
47 views
How to replicate windows name sorting in linux?
I need to print a list of files to a text document in the same order they show in the windows explorer alphabetic sort, but I can't find any method of sorting with ls | sort that shows the exact same ...
0
votes
0answers
43 views
Group rows in excel based on cell criteria, then sort data by a different criteria without losing the grouping
I am struggling to group cells together in excel and sort by a different criteria. I work for a telco company and look at repeat trouble tickets. I would like to group the rows together based on ...
0
votes
1answer
14 views
Sorting a text file based on data before the first comma
I have the following text file that contains rows in a format of [Number,IP address] and want to sort it based on the number portion. I tried using the command
sort -r -k 1 -t"," Input.txt &...
1
vote
2answers
20 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 ...
7
votes
2answers
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:
0
votes
2answers
45 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)
0
votes
1answer
34 views
Default files sort order used by “dir” command / core Windows 10
tl;dr I cannot replicate sort order used by dir command in Windows 10, neither within File Explorer nor Total Commander. I have tried to change sort order based on many different columns and still ...
0
votes
0answers
15 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
...
0
votes
1answer
17 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 ...
1
vote
1answer
26 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
votes
2answers
40 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?...
0
votes
0answers
5 views
Sort contact entry data in Google Contacts / Samsung Contacts
Is there any way in Google Contacts or Samsung Contacts to sort the phone numbers, e-mail addresses etc. for a contact entry? I don't mind if it is achieved in the Google or Samsung apps, through the ...
1
vote
1answer
27 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 ...
0
votes
1answer
39 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 ...
2
votes
2answers
239 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 ...
2
votes
1answer
27 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 ...
2
votes
1answer
21 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 ...
2
votes
1answer
52 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 ...
0
votes
1answer
25 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, ...
0
votes
0answers
13 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 ...
1
vote
1answer
76 views
How can I sort an email alphabetically in bash
I am trying to sort a list of emails in alphabetical order in bash to no avail
The emails involve numbers and periods:
kori.flap10@flap.com
flap39@flap.com
flap.flap@flap.com
flap@flap.com
k.slick20@...
0
votes
0answers
21 views
Sort rows using function on selected data
I want to sort numbers in selected rows with the help of either function or variable method. I have random numbers from 1-80 in each row (about 20,000 rows unsorted).
for example: enter image ...
0
votes
1answer
42 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 ...
0
votes
1answer
30 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 ...
2
votes
1answer
66 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 ?
0
votes
0answers
36 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 ...
1
vote
1answer
42 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.
0
votes
2answers
286 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 ...
0
votes
0answers
21 views
Batch or not - Open Folder And Sort
I am looking for a solution for sorting pictures by year. Let's say I have a folder "unsorted". There are more than five thousends folders. Each folder contains pictures, saved in different ...
0
votes
1answer
27 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:
...
0
votes
1answer
93 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 ...
2
votes
1answer
54 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 &...
0
votes
2answers
46 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-...
0
votes
0answers
26 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, ...
0
votes
1answer
33 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 ...
1
vote
1answer
31 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, ...
0
votes
0answers
2 views
How can one “align” several datasets with the same x-axis, but different x-axis values?
I have acquired several 2D datasets (x and y values) at different timepoints (the z dimension), however the x-values are inconsistent (see attached image). My goal is to produce a single table with x ...
2
votes
3answers
215 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)
...
0
votes
0answers
50 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 ...
0
votes
1answer
34 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 ...
0
votes
2answers
83 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. ...
2
votes
3answers
323 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 ...
1
vote
1answer
253 views
Sorting in outlook by flag - change sort order
I would like to make outlook to sort my messages in a certain search folder by the following order:
First - sort by flag status in the following order: followup flag first, unflagged second, completed ...
0
votes
2answers
31 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 ...
0
votes
0answers
16 views
Sorting Excel rows
I'm trying to make the formula working on each 2 rows respectively, but I couldn't
FX SWP product is displayed in 2 rows. I want to separate the two rows, and put one in the Short sheet and one in the ...
0
votes
1answer
283 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 ...
0
votes
1answer
28 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 ...
