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
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 ...
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 ...

1
2 3 4 5
13