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
1
vote
1answer
10 views

A command to sort stdin in ASCII order

Sometimes, GNU sort does not behave as expected. Here's an example: > bind | sort (This assumes you're using fish. In bash, the equivalent is bind -p.) All of the non-alpha characters in the ...
0
votes
0answers
24 views

Collect Group Members & Administrator from different group on AD (Powershell)

I need your help about a powershell script & I’m a newbie on Powershell. I have to collect members & administrators of different groups from AD, in .CSv format. I have a specific way for that ...
0
votes
0answers
24 views

How to fix sorting

I'm afraid to describe my problem properly, because last time I did it became falsely marked as a dupliccate and there is no answer to my problem yet. So: This is the sorting I want I don't want it ...
0
votes
0answers
12 views

Windows Explorer sorts files wrong/ in a different way than folders [duplicate]

The Windows Explorer sorts my files in a rather "interesting" way when I want them to be sorted by name. They are sorted like this: VRU3 Mitschrift VRU3.2 Mitschrift VRU3.2 VRU3 Instead of ...
0
votes
0answers
10 views

In Tableau, when using “Sort By” Field option using a parameter, how can the aggregations (average and sum) be changed as the parameter changes?

I am trying to sort a colored stacked bar chart in my view. I created a "Sort By Dimension" parameter in which I can choose which field I want to sort by. There can be two selections here. ...
0
votes
0answers
37 views

“Date modified” of downloaded file is in the past - Windows 10

I like to order most of my folders by "date modified". But sometimes I will download a file with a timestamp in the past. This is very disruptive to me (I have to check chrome downloads to ...
0
votes
0answers
25 views

How to sort a list on Excel by letter first rather than the number, even if the cell value starts with a number?

Is there a way to sort a list by the first LETTER of a cell rather than the first NUMBER. I need to sort a list of addresses by the street name not by the street number so I can see the multiple ...
0
votes
1answer
36 views

Excel is not sorting letter correctly

I have a weird problem with Excel: it is sorting the letter "CH" incorrectly (it places "CH" after "CZ"). As you can see in the attached image, it only happens with "...
0
votes
2answers
51 views

How to sort files in Windows explorer in custom order?

I have a great deal of folders. Each contains more than 30 files. I’d like to sort these files in a custom order. How do I create a custom order and have it sorted out the files the way I want? I was ...
0
votes
0answers
40 views

Matching 2 Data Set rows with similar column headings

I have 2 data sets A-Q (left) and U-AA (right) I am trying to match the rows on the (right) U-AA with the rows on the (left) A-Q Once a record on the right matches the first like record to the left ...
1
vote
2answers
33 views

How to change the default sort order in Windows Open window?

How to change the default sort order in Windows Open window? Example: Paint => File => Open => /* need to order by date by default */.
0
votes
0answers
22 views

Find recently modified files of a specific type in Windows 10

I'm looking for a file which I don't remember the file name and path but do remember the file type. Can I see all files of a specific type in all directories in the order of last modified time?
0
votes
1answer
25 views

Post-processing of multi-column CSV: remove dublicate lines + sort

I am dealing with the csv produced by the concatenation (via cat) of several CSVs: ID(Prot), ID(lig), ID(cluster), dG(rescored), dG(before), POP(before) 1000, lig40, 1, 0.805136, -5....
0
votes
0answers
11 views

Pivot Custom Listing (unable to save)

I have created a custom list for Pivot by going to <Options, Advanced, Custom list> method. However when I close the excel file and reopen it, the custom list goes away. Any way out to save the ...
0
votes
1answer
25 views

Sorting lines according a column value

I need to sort all of the linnes in the csv filles according to the number contained in the second column from min to max, ignoring the first (header line): ID(Prot), ID(lig), ID(cluster), dG(...
0
votes
0answers
43 views

Inputting data into a sorting table in Excel

For my project I need to design a warehouse, in which I sort the products based on the amount of times it is requested, with the most requested product going to the location with the shortest travel ...
3
votes
1answer
222 views

Sorting fomulas in an Excel table

For my project I need to arrange locations based on the lowest driving time to different locations. I simulated the driving distances (Row D, E & F), but the height depends on the products which ...
0
votes
0answers
29 views

Sort Bullet list alphabetically, maintaining formatting in Notepad++

Hello I am trying to sort lists alphabetically that contain entries separated by • and I need it to maintain formatting. I am using Notepad++ and can also use Python Script (Plugin). Example source: |[...
0
votes
1answer
15 views

PDF-Pages To PNG And Back To PDF In A Hotfolder Via Script

For security-reasons I want to decompose PDF-files and put them back together (like printing them and scanning them back in). I want to offer this for my users, so I would like to script a kind of ...
0
votes
0answers
10 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
29 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
51 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
48 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
50 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
57 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
70 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
33 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
45 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
248 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
22 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
101 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
15 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
84 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
46 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
31 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
37 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
43 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
362 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 ...

1
2 3 4 5
14