Sorting is any process of arranging items according to a certain sequence or into different sets.

learn more… | top users | synonyms (1)

18
votes
1answer
14k views

Sorting lines in Notepad++ without TextFx plugin

Current version of Notepad++ is 6.6.3. Version 6.5.2 is the first, that introduced native (without plugin) sorting function to Notepad++. At least that's what they claim. Because, even though we're ...
0
votes
0answers
9 views

Sort mails by 3 criteria on Thunderbird

I would like to sort my mails by 3 criteria, on this order : Date (new mails up the list) Read state (unread messages upper) "Starred" (starred messages at the uppest) But it seems that it is ...
44
votes
12answers
55k views

Unix/Linux find and sort by date modified

How can I do a simple find which would order the results by most recently modified? Here is the current find I am using (I am doing a shell escape in PHP, so that is the reasoning for the variables): ...
4
votes
1answer
212 views

Is there a way to keep the selection in Windows 2008 Explorer when changing the sort order

A nice feature of Windows Explorer up to Windows Server 2003 at least (I don't have easy access to Vista or Windows 7 to know when this was lost) was that you could select multiple files (or folders) ...
0
votes
1answer
3k views

How to sort only part of multiple columns in Excel

I want to highlight, for example, rows 5-15 across columns C, D, and E, and sort only that block in ascending order by one of the columns. The trick is that I want all included columns to follow suit ...
11
votes
7answers
6k views

Sorting human readable file sizes

How can I sort a list using a human-readable file-size sort, numerical sort that takes size identifier (G,M,K) into account? Can I sort "du -sh" output for example? Problem: Consider the problem of ...
0
votes
0answers
13 views

Spreadsheet Function Help - From A Table Of Names And Birth Dates Pull A List Of Names As Of A Reference Date And There About

I have posted this question before, and got half-solution. Pls have a look at this link to get an idea. http://yogi--anand-consulting.blogspot.in/2014/11/yogifrom-table-of-names-and-birth-dates.html ...
2
votes
2answers
51 views

Sort structures in file [duplicate]

For example I have file consisting of structures like name = { foo = bar; ... }; So in file there are lots of structures like this. How can I sort them (I'm using vim but emacs is surely ok ...
2
votes
0answers
88 views

“Sort Lines” disabled in Sublime Text

I'm wondering why I can't click on Edit > Sort Lines in my Sublime Text 3 ? I often use it and I don't think I've done anything which could disable it, so I don't know where to search... What ...
2
votes
1answer
862 views

Pivot table : absolute value of grand total in Excel

My grant total is generated by summing values of COLUMNS of ITEMS for a given SUBJECT (For each SUBJECT I have a list of ITEMS and I want to make a grand total of the values of these ITEMS). The ...
0
votes
0answers
26 views

Custom sort selection

I would like to be able to sort a selection based on the order of another range somewhere in the same workbook. While I realize I could add custom list and then sort the selection based on this, this ...
0
votes
0answers
8 views

Order by sub-type in Windows File explorer

Say I have the files: File1.bla.txt File1.htm File1.foo.txt File2.bla.txt I want to order them first by type (txt/htm) and then by file sub-type (if it has any: bla/foo). So: File1.htm ...
2
votes
1answer
287 views

Remember icon size, sort order, and sort options per-folder on Windows 7

Sometimes when I change the icon size in one folder, all other folders are changed, too. Sometimes they are unchanged: Sometimes when I change the sort order, all other folders change too, ...
0
votes
2answers
32 views

Dates in Excel - sorting

Is it possible to sort a list of dates by week? For example, if I have a list of specific dates and I want to group them into week 1, week 2, week 50 of the year, is it possible?
0
votes
1answer
203 views

Unable to sort selected cells within the Table in Excel 2013

I created a Table in Excel 2013 but I want to sort only selected cells. The table range is A1:I200 but I only want to sort A150:I200. I tried selecting the cells, right click, sort, it sorted the ...
38
votes
10answers
25k views

Unix: ls, how to sort first directories then files etc

I would like to use ls command to first show direcotries and then files. I tried ls -la | sort -k 1 But I got a wrong order.
0
votes
2answers
26 views

Sorting in Excel

I have entries in Excel that are like this: 52173 PURCHASE USA*SNACK SODA 52172 PURCHASE USA*SNACK SODA 668414 PURCHASE REDBOX *DVDRESERVATION I would like to sort the rows ignoring everything ...
4
votes
4answers
1k views

Windows explorer: sort by date modified

Is it possible to properly view the contents of a folder sorted by modification date in Windows explorer (Windows 7)? I can sort by the date modified column, but folders and files are seperated. I ...
2
votes
2answers
1k views

Is there a way to preserve or remember sort-by preferences for different folders in column view in Mac OS X?

For example, I would like to have folders in column view, and to have Folder 1 always to show files sorted by kind, and Folder 2 always to show files sorted by date created. I'm running Leopard, with ...
1
vote
1answer
58 views

How to use linux bash “sort” command in a portable script?

I am writing a bash script and I want to make it portable, to have the same results in the other computers. From this question I learned the system settings, like language settings and possibly other ...
0
votes
1answer
29 views

Unexpected result from sort command of linux bash

I have a file foo.txt with this content: chr1 15 chr11 5 chr11 8 chr1 7 chr2 23 chr1 35 I tried to sort it first according to the first column, and then according to the second ...
3
votes
2answers
769 views

How do I randomly sort groups of multiple lines in a multi-GB file?

I've got a multi-GB file that has elements in 4 lines, and I would like to have every 4 lines randomized in another file, this is, keeping each four lines grouped and randomize those sets. Is there an ...
2
votes
1answer
43 views

Can I sort in excel but read the cell values from right to left?

I have an excel worksheet list of names and email addresses. Some of the email addresses, however, are cutoff on the right and have "...". For example: some email addresses are "test@test_user...". ...
1
vote
1answer
166 views

How do I quickly parse large ASCII files for matching records?

I have lots of files containing data records, stored as space-delimited ASCII files. Each record is a row containing numeric data, with some columns integer and others floating-point eg. 1 1 5711 4 ...
16
votes
6answers
16k views

In bash, how to sort strings with numbers in them?

If I have these files in a directory cwcch10.pdf cwcch11.pdf cwcch12.pdf cwcch13.pdf cwcch14.pdf cwcch15.pdf cwcch16.pdf cwcch17.pdf cwcch18.pdf cwcch1.pdf cwcch2.pdf cwcch3.pdf cwcch4.pdf cwcch5.pdf ...
0
votes
2answers
30 views

Sort Excel Row Based on Values in Another Row

Sorry if this question has already been answered, I looked but I didn tfind anything that was quite what I am trying to do. I have a lot of spreadsheets where I have something like: A|B|C|D|E|F... ...
4
votes
1answer
2k views

Sorting by Date - Very Slow

I'm using Windows 8 RTM. I have about 1,100 files in a folder. When I sort by date (in either direction), The address bar shows the green progress indicator as if it's working hard to perform the ...
2
votes
1answer
1k views

specify the sort order in “copy /b *.dat foo” in Windows cmd

Normally, when I do a copy /b *.data foo in Windows cmd, the *.data files are catenated in the sorted order into the destination file foo. This matches my desired behavior. However, I just met a ...
2
votes
2answers
372 views

Excel: searching for a maximum lower than X

From the sorted list of values, I'm looking for a maximum that is lower than X Example: A B C 1 1 X=7 2 3 3 5 4 8 ANS=5 Do you have any smart ideas for this problem?
0
votes
2answers
27 views

Sort files in Windows by name - according to date

I have a bunch of PDF invoices in a folder. They are named according to their dates. For example: 28-02-13.pdf 28-02-14.pdf 28-03-13.pdf 28-06-13.pdf 29-11-13.pdf 30-04-13.pdf 30-04-14.pdf ...
0
votes
1answer
18 views

Excel 2007. Data Tab is grayed out. Nothing on that Tab is available

I'm trying to sort a file to which I add rows daily. I usually have no trouble sorting, but from some reason all the items on the Data Tab are 'grayed out' and unavailable. Any idea what's caused ...
0
votes
0answers
16 views

How to custom sort Window Explorer on 'Comments' column

I've added Comments to .pdf files using the program File Metadata, and then I enabled a Windows Explorer comments column. This sorts reverse alphabetically i.e. Zaphod, Widget, Constantine, Adam, ...
0
votes
1answer
323 views

Changing default sort order in Windows 7 desktop search

If I do a search (usually, I'm looking for an email), the results are presented in date-modified order by default I can do Sort By / More... and select Date Received, then Sort By and select Date ...
0
votes
1answer
58 views

Sort numbers in left to right in ascending order

How to arrange in ascending order from left to right in vi or with the sort command? Sample before arrangement: 2 3 3 6 5 1 4 2 5 8 I want it in this way: 2 3 3 6 1 5 2 4 5 8
1
vote
6answers
723 views

Best way to manually sort random text files?

I have about 1000 text files and I need to view each, and move it to a folder if it's the correct one. I can only do basic sorting by length/size, and I can't grep because the text is random. How can ...
3
votes
4answers
2k views

How to sort Spotlight results by size in the Finder?

How do I sort search result by size in Finder? I would prefer some sort of setting, or shell plug-in. I'm using this to clean my hard drive by finding and deleting the largest files first. I'm not ...
0
votes
1answer
95 views

Sort & Ranking Functions in Excel for Time AND Number Values in one Column

I have a spreadsheet that is being used to track and score a fitness competition, each workout has a time cap, so athletes that complete the workout under the time cut off are given a time as their ...
1
vote
0answers
43 views

Separation of work, personal, and private , for all things tech?

Increasingly I'm finding it's very difficult to separate anything on my computers and devices. Everything syncs everywhere, I need to do work from my home computer, I need to do personal things from ...
3
votes
2answers
342 views

Alphanumeric sorting in Excel

In Excel, is it possible to sort alphanumerics from a-1, a-2, a-3...a-123 instead of a-1, a-10, a-100, a-11? Sorting via oldest to newest or via A-Z, definitely won't give me the result I want. I've ...
0
votes
1answer
22 views

Using Outlook 2010 Custom Views

I frequently switch between emails sorted by date (newest on top), sorted by From, and sorted by conversation (oldest on top). I'm tired of right clicking and sorting my emails, especially with ...
0
votes
1answer
27 views

Sorting and showing the most repeated row (value)

I have a sheet containing over 200k+ rows with values like this, 10.10.10.10 11.11.11.11 12.12.12.12 10.10.10.10 10.10.10.10 I want to be able to show the most repeated row at the top or extract it ...
0
votes
1answer
29 views

how does sort compare lines?

I've always assumed that sort without any additional arguments, will sort a file in lexical order. However today I ran across following test case: sort test2.txt a/a a/c a//c a/d As you can see the ...
3
votes
2answers
438 views

How to reorder folders? (as displayed in `ls -U`)

I've got a number of unordered folders on a memory stick, which my car stereo shows in order of their real position on the stick (i.e. same as ls -U) What's the easiest way of physically reordering ...
1
vote
3answers
708 views

Why does my exchange message filtering rule not work?

I have two rules set up to sort incoming bug reports. The first is specific to a single device: Apply this rule after the message arrives sent to SMS Distribution and with ...
0
votes
3answers
168 views

Excel filter duplicate values in column A and filter out rows which have column C blank

How to filter duplicate values in column A and filter out rows which have column C blank. I have 2200 rows in Col A (the first 1400 rows also have data in Col B & C, the next 800 rows are ...
0
votes
0answers
148 views

Why am I unable to sort data in Excel?

Here is what my spreadsheet looks like: I am trying to sort these invoices first by type (Column B) then date, and finally by amount (which shouldn't apply, but why not). I have checked for ...
1
vote
0answers
602 views

Path Finder: How to sort files by date, but folders by name?

This is possible in Total Commander. How can I make such separate sorting in Path Finder as well? I like to sort files by date, but I don't see any point in sorting folders this way - they just jump ...
0
votes
0answers
50 views

why is my sort slower with more ram?

System specs below. I recently purchased 2X4 RAM: Corsair XMS3 8 GB (2 x 4GB) 1333 MHz PC3-10666 240-Pin DDR3 Memory Kit CMX8GX3M2A1333C9 I already had 2X2 in there for a total of 12GB: Corsair ...
1
vote
1answer
493 views

How to sort folders by last characters of folder name in Windows 7?

I have a stack of client folders with names like this: eastcoal 008 mee 022 orr 047 owaka 032 owen 025 powernet006 redpath 031 Normally this works, but sometimes I'd like to sort by the number. ...
0
votes
0answers
21 views

Ignore certain characters while sorting data in libre/office calc

I have a list of transliterated chinese terms in a table showing Wade-Giles (W.-G), chinese characters and Pinyin transcription. Example, (sorted W.-G column only): P'u Te Ssu P’u t’uo-shan Pai ...