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
1answer
17 views

How to sort alphabetically based on a particular column in notepad++?

I was unsure how to word the inquiry. I have a huge swath of a few thousand entries i'd like to sort alphabetically but using the built-in notepad++ sorts numbers first and in my case, i need a ...
0
votes
0answers
15 views

sorting folders within a folder on windows 10 based on the # of subfolders they hold

is there any way to sort a folder so that the folders that have the most sub folder in them to go to the bottom and the ones with less or no sub folders to come on top? for example if a folder has ...
0
votes
0answers
34 views

Automatic mass re-sorting including rows

I'm an Excel beginner so please explain every step clearly! I've created a large spreadsheet of German word frequencies for work following an old frequency dictionary, and now the dictionary has been ...
0
votes
1answer
20 views

I want to sort text phrases by their number of words with Notepad++

I would like the program to be able to select or identify a sentence automatically (from one point to the next or from one point to the question mark or to the exclamation mark) and to order each ...
0
votes
1answer
95 views

Sorting almost-duplicate lines by their share of identical beginning characters

Is there a *nix tool/way to show each two lines (possibly adjacent via sort) that are almost duplicate top-ordered by the number of similar characters in same positions between each of those to lines ?...
2
votes
0answers
59 views

MS Excel 365 Not Sorting

I have recently started experiencing a weird bug with excel, for some reason it has stopped sorting columns. It does not matter the way I try to sort, it just does not do it, however, filtering does ...
0
votes
1answer
30 views

How to output most common strings in a text file?

Background I have a text file containing a list of databases and entries in those databases. Example text file: Database 1 1. Book about abc. 2. Thesis about abc. 3. Book about xyz. Database 2 1. ...
-1
votes
1answer
34 views

Can I change the default match method in Excel from “Less than” to “Exact match”?

By default, MS-Excel uses 1 - Less than as match method in functions like vlookup and match. Apparently Excel assumes the data is sorted and if the value I am looking for is missing, the value just ...
1
vote
1answer
61 views

How to fix VLC sorting playlist wrongly?

Scenario: VLC 3.08, the playlist have more than 20 tracks and is sorted as follow 1. VideoA 2. VideoB (...) 11.VideoX 12.VideoY (...) 20.Video Z (...) Problem: The sorting by title ends up like this ...
0
votes
0answers
169 views

Modify the locale collation order in Windows 10

The collation order is what determines the order strings are sorted in for a given locale. It comes in two layers, the root order which determines that all variants of A is treated as a (Á À Ä Ã ...), ...
0
votes
1answer
111 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 ...
0
votes
0answers
15 views

Sorting Folders by Name and Files by Last Modified in Windows Explorer [duplicate]

I already keep my folders on the top while sorting by last modified thanks to this trick. However, all it does is sort folders and files separately. I'd like to keep my folders in alphabetical order ...
5
votes
1answer
580 views

Windows alphabetical file sorting: why do spaces have special treatment?

I've noticed that in Windows, when you sort files alphabetically, there's a strange thing that happens when you have file names that extend one another with spaces. For example, say you have two files,...
0
votes
1answer
49 views

How would I find how many rows in excel contain multiple unique values?

I have a list of all buyers in our state with their account number and the zip code they live in. I'm tasked with finding out how many buyers live in each zip code. |Account ID|Zip | | 13 ...
0
votes
0answers
29 views

In which order does Windows Explorer sort folders when sorting the results of the search by size?

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 decide the ...
0
votes
1answer
17 views

Create a link so that information across multiple rows can be matched to a unique ID, and will be sorted/filtered based on that?

So I want to be able to link the ingredients for Pizza (Flour, Tomatoes, Pepperoni) to the Unique ID, 1. If I sort or put a filter on the ID column so only show '1', I want all the ingredients to ...
1
vote
0answers
22 views

windows 7 sortings automaticlly

I need to change the order that windows explorer sorts filenames. Now every time I scan multiple files to TIFF and get one separate file for each page it sorts the first page as last: doc_.1.tif ...
1
vote
2answers
62 views

How to sort two columns of numbers to minimize the differences between them?

I'm sorting two columns of numbers. One is a series of spools of wire, and another is a series of needed lengths. I want to optimize the selection of spools for the needed lengths, while flagging ...
0
votes
0answers
24 views

Sorting Data Pulled from Another Sheet

I have two worksheets in a workbook I'm designing for teachers to use next year. One worksheet is where they enter student information and testing data and one worksheet is a general student roster. ...
1
vote
0answers
20 views

Sort by type while retaining numerical ordering in Explorer

Windows XP and later OSes have a NoStrCmpLogical API that allows sorting numerically rather than lexicographical. All references say this is not supported until after Windows 2000, yet, somehow that ...
0
votes
1answer
31 views

Excel pivot table sort by values

I've done quite a bit of searching but cant find working instructions on how to sort a pivot table in Excel by a field that has been placed in the Values area. The best I've been able to come up ...
0
votes
0answers
21 views

Extract emails from files contained in various folders with grep and sort them

I am trying to extract all email address from a specific TLD from files that are located in a big folder and in some sub-folders (maybe this is the issue? nb. I am in the correct directory where the ...
0
votes
0answers
25 views

permanently disable “my data has headers” option

I rarely have a header row and want to simply select the range (usually 4-5 columns and anywhere from 5 to 30 rows) and use the a-z (or z-a) button to sort against the 1st column. More than half of ...
0
votes
0answers
20 views

Acrobat: Sort attachments panel by location

Using Adobe Acrobat XI Pro Windows 10 Pro 64 bit In the attachments panel, the attachments are sorted by name by default. I can change the sort by clicking the heading of any of the columns, except ...
0
votes
1answer
160 views

Use find to delete all images under given dimensions

I just used Recuva and Photorec to recover some data off an accidentally-formatted drive. Naturally, the result is every intact file that ever existed on the drive during its lifetime. This means tens ...
0
votes
0answers
79 views

Windows 10 - “Sort by Date” but with files on top?

I've noticed that for some reason, anything I unzip uses some other Modified by Date that is far older than when the folder was unzipped on my PC, that makes it very annoying to go through my files. ...
1
vote
1answer
51 views

Windows CMD sort retaining header?

Need to sort in Windows a large CSV-like file with a header row (~7 million rows). Can successfully do this with a CMD command sort, but it includes the header row in the sort. I would like to keep it ...
1
vote
1answer
43 views

sorting various headings in rows

A friend of mine has given me his excel collection of recipies. He has around 500 recipies which has split into each letter on a different sheet. He wants me to then sort the recpies for each letter ...
0
votes
0answers
18 views

Find files based both on creation and last modification date

I want to move the older half of my drive. The problem is, some of the oldest files are not the actual originals, so they have a comparatively very recent creation date, and some of the actual ...
0
votes
1answer
173 views

sorting lines from multiple log files in LINEAR TIME by timestamp(primary key) and by path(lexicographically)(secondary key)

I am trying to write a bash script that receives a path to a directory as its argument and outputs all lines of all log files (from the given directory and all its sub-directories) sorted by a primary ...
0
votes
0answers
27 views

How to sort multiple partitions by their drive in Explorer's This PC window?

I have multiple partitions from 3 HDDs. Is there a way to sort them by the HDD they're on? I tried Sort by, but didn't work. Here's a screenshot
0
votes
0answers
18 views

I have dates set to short date format, but I'm not getting the option to sort by newest to oldest, only A to Z

The dates are formatted to short date format but I'm only getting the option to sort A to Z, not Oldest to Newest or Newest to Oldest. I don't know what I need to change to sort by actual dates, not A ...
0
votes
0answers
136 views

MariaDB getting error “1038 - Out of sort memory, consider increasing server sort buffer size” when sorting on TEXT field

I am a developer. I am working with Wordpress on a dedicated server with CENTOS 7 and MariaDB 10.2.27. In certain situations, when using the ORDER BY statement, the server returns the [Err] 1038 - ...
0
votes
1answer
38 views

Disabling automatic sorting in Windows Explorer

It seems Windows 10 automatically sorts files in an Explorer window with respect to some property. I want to disable automatic sorting to occur when I rename files. For Grouping files, I can select "...
0
votes
0answers
77 views

how to Natural sort on Elasticsearch 2.4.4

sorry for I'm not good at English. I want to sort naturally on elasticsearch 2.4.4. For example, with these documents: { name: "Bob: 3 points" } { name: "Bob: 10 points" } { name: "Bob: 2 points" } ...
1
vote
1answer
126 views

Where are the folder view and file sorting/grouping settings stored in Windows?

I can observe that Windows 10 remembers folder settings such as "Sort by" and "Group by" for each folder. Where are those settings and customizations stored?
0
votes
1answer
26 views

Sorting Excel Grids - Sort function vs Filters

Wondering if using Filters is recommended as opposed to using the Sort function in Excel? I ask because I find that when I use filters, sometimes the last column doesn't sort with the rest of the data....
33
votes
1answer
5k views

Why does the `ls` command sort files like this?

As I was trying to reverse engineer the ls command, I came upon an interesting behavior. When I make 3 files, foo.png, foopa.png, and fooqa.png, ls sorts them as foopa.png, foo.png, and fooqa.png. I ...
1
vote
2answers
217 views

Win 10 - how to sort and display parent folder in a way, and 100’s of subfolders sorted differently from parent folder?

I already asked this, but maybe in a wrong forum... I have almost a thousand folders, in Win 10, for each of my clients pictures, each folder named by the client’s name. All these folders are ...
1
vote
1answer
164 views

Sorting issue with Windows 10 File Explorer

I'm using 0-9 and A-Z to name files. For example, ex_1A, ex_23, etc. I pad to 2 digits, so 9 would be ex_09. In Windows 10 File Explorer, it sorts things completely wrong: ex_00 ex_0A ... ex_0Z ...
1
vote
0answers
58 views

Linux merge sort is *slower* that full sort?

I'm using Linux merge sort (sort -m) to sort a large group of presorted files. I was assuming that merge sort would be considerably faster than a full sort on the unsorted data but that's not what I'm ...
0
votes
1answer
57 views

append multiple files in descending order in dos cmd

I have some files with names 93112.txt, 93111.txt, 93110.txt etc. I want to put them into a single combined file such that the largest number file goes in first, then the next smaller ...and finally ...
0
votes
0answers
41 views

Folder ascending/descending order changes randomly

I'm on windows 10, and some of my folders that I use all the time will swap ascending/descending order, seemingly randomly. I have some folders that I like to keep sorted ascending and others that I ...
-1
votes
1answer
32 views

Sorting rows: 6 transactions with date and action information grouped together

I need to organize transaction information in a spreadsheet by ascending date order. Each row represents a single person and the last 6 transactions in their history. The problem is that while the ...
0
votes
1answer
111 views

Identifying and sorting duplicates in Excel

I have a list of values in column A. Some of the values occur once, some occur twice, some occur more than 2 times. In column C, I would like to only list the values from column A that are repeated ...
0
votes
1answer
50 views

Excel - Find unique values in one column and corresponding values from another

I have a database export of components and labels in two columns. Column A contains a component and column B contains the labels associated with the component. The same component can show up multiple ...
0
votes
1answer
26 views

Set range on x, sort and count in Pandas

I have a dataframe, and I want to set several ranges for x in a certain column. For, example I have 1000 entries in column C with different values (from 0 to 100). I want to sort the values from min ...
1
vote
1answer
336 views

Differences in A-Z sorting in Explorer vs Excel

I have a list of files in Windows Explorer sorted ascending by name 3a.txt 6a.txt 10a.txt In Excel I have the names of these files in a column, I sort them A-Z and except them to be the same as the ...
0
votes
1answer
119 views

Sorting one column of data into multiple columns

If I have a list of data in a spreadsheet like this: John 123-456-7890 john@email.com Sally 987-654-3210 sally@email.com . . . What would be the quickest and cleanest way to sort the data into rows ...
0
votes
2answers
86 views

How persistent is “sort by date”?

If I sort my files by "date" in File Explorer, will it hold up if the files are modified? Will "sort by date" and "order by ascending" always sort by the date the file was downloaded/created?

1
2 3 4 5
13