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

learn more… | top users | synonyms (1)

1
vote
2answers
26 views

How to find (or sort into sub-folder) multiple TIFF images with layers and/or transparency?

I have a folder with many TIFF files which I need to convert to JPEG. However some of the files have layers and/or transparency and these I don't want to convert. So how can I move these TIFF files ...
0
votes
0answers
14 views

Can I add a custom sort order to Word 2013?

In previous versions of Word it was possible to add a new sort order...instead of the provided sorts for number, date, etc. you could add days of the week, months, etc. Is that possible in Word 2013? ...
3
votes
2answers
838 views
15
votes
3answers
5k views

Equivalent of gnu `sort -R` on OSX?

The GNU sort text utility features a non-standard -R option to randomize input lines (presumably by sorting on a hash). OSX sort does not have this extension. Is there similar functionality ...
1
vote
2answers
45 views

Given key-value content, how do I group values by key and sort by value?

I've the following sample input format (file or stdin): key1: 1 key2: 2 key3: 3 key1: 4 key2: 5 key3: 6 Is there any few-liner which can group values based on the key and then sort? Expected ...
0
votes
2answers
6k 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 ...
0
votes
1answer
2k views

Sort doesn't work properly for cells with references to other cells

I have two tables in Excel 2010, the second table has the last column filled with cells that reference the last column cells from the first table: For instance, the value of the first cell in the ...
0
votes
0answers
14 views

Kingsoft Spreadsheets = “Free” version of Excel…won't Sort by column Headers any more

I've had this happen even in Excel, but it's always annoying. I'll be sorting just fine, no worries, then boom, it will refuse to sort by the column Header and will only look at the first cell of data ...
43
votes
10answers
30k 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.
1
vote
1answer
87 views

Sort array in the sourcefile

I have written a script using Notepad++, and in it I have hardcoded an array. This is a script which I have expanded on over the years, and thus the array have gotten "unsorted". Let's say that it now ...
1
vote
1answer
30 views

Lining up sets of data in Excel (both with unique keys)

A related question asks how to line up two sets of data in Excel. I am struggling to figure out how to do this when you have values in both lists which don't exist in the other list. Ie: how would ...
6
votes
6answers
10k views

Outlook 2010 Unable to Categorize Messages

I am unable to categorize messages in my inbox. What I'm talking about is the ability to assign a color category. I'm accustomed to being able to just click the icon in the ribbon of the open message ...
0
votes
1answer
55 views

How to sort sheet by groups of three rows without changing internal arrangement of groups

I created an Excel file showing a list of golfers and their scores on 18 holes. I want to sort by the Net Total, while preserving the rest of the formatting. When I try to sort the usual way, I ...
6
votes
3answers
182 views

How to Sort Animated GIFs from Non Animated GIFs?

I have a folder with lots of images and i want to sort animated GIFs from non animated GIFs and move the animated GIFs to a new folder. Tried with software like XnView and XnViewMp for Windows but ...
0
votes
1answer
15 views

Sorting files in a folder by the application that created them

I'd like to have a better idea of why there are certain files in my TEMP folder, so I'm wondering if there's any record kept in Windows 7 about the application that created a particular file. I ...
1
vote
1answer
58 views

Alternate Row Colors of Duplicate Data in Excel

I am working with a dataset in Excel that contains duplicate values and non-duplicate values that are numbers. I would like each duplicate value group to have alternating shades via Conditional ...
1
vote
2answers
268 views

Can I change where win7 shortcuts sort in relation to folders?

If i have a group of folders, and somehow i need a shortcut to a folder to be "in the middle" sequentially, how do i fix that? Changing sort by type does not help, sorting by name does not seem to ...
0
votes
9answers
30k views

My excel spreadsheet won't sort/alphabetize properly

I have a spreadsheet with multiple columns and over 4000 rows. I need to sort, then alphabetize my report and everytime I do, there are 43 rows that do not sort with the rest of the report; they go ...
1
vote
1answer
22 views

Are different non-alphanumeric symbols—when used at the beginning of a filename—treated differently when sorting alphabetically?

I’ve long used the trick of adding a dot to the beginning of a folder name so that it always appears at the top of a list of folders when they are sorted alphabetically. But is there an ...
0
votes
1answer
24 views

Linux sort Command: how to sort on a number embedded in a field?

I'm on RHEL 6 using BASH. I'm trying to sort some lines in a file, by a number that is embedded in a field. The name of the file is word.txt. This is the command I am using: sort -n -k4 word.txt ...
0
votes
2answers
49 views

Select a number of rows from a set in Excel

I have a list of users in locations within my company. Vastly reduced from the 130,000 or so in reality, the data looks like the example at the end. What I need to do is to select a number of users ...
3
votes
3answers
74 views

How to correctly sort calendar months “mmm” with AutoFilter?

I need to use filter to sort calendar months in mmm format. Data > Sort > Custom will do it but I cannot make filter work. Months are in a column eg SEP, APR, JAN, APR, etc. Filter just does ...
3
votes
3answers
566 views

Unix sort keys cause performance problems

My data: It's a 71 MB file with 1.5 million rows. It has 6 fields All six fields combine to form a unique key - so that's what I need to sort on. Sort statement: sort -t ',' -k1,1 -k2,2 -k3,3 ...
6
votes
2answers
4k views

How can I disable Windows Vista / 7 Explorer's “auto sort” after file copying?

One of the things that really annoys me in Windows Vista / Windows 7 is the new "auto sort" feature. In Windows XP, whenever you copy a bunch of files to a folder, they are all placed at the end of ...
0
votes
2answers
24 views

Sort on ID, then sort on date, then remove lines which have the older date?

I have a couple of tab delimited files. Each file is structured like so: ID Title Rating Date_Rated What I want to do is merge all these files into one, ...
1
vote
1answer
14 views

How to make sort consider blanks (GNU coreutils)

How can I make sort consider blanks? Original file: n c n b n a What I get with sort file is this: n a n b n c So how can I come to this order: n b n c n a Version: sort (GNU ...
0
votes
0answers
47 views

Sorting HTML content based on second line of table cell

I have an Windows text file, containing the text of an HTML table (no header, no footer) with each cell of the table not in alpha order. I'd like to alphabetize the tables, a la: REDACTED-TITLE-1 ...
0
votes
2answers
998 views

Sort by bar dissapeared in Windows 7 folder explorer when viewing icons

Under Windows 7 sorting by thumbnail icon files takes longer, or a different path of clicks. I have to switch viewing files in details mode (select from the sorting bar) and then sort by date ...
1
vote
2answers
275 views

Sort by multiple columns in Windows Explorer 8

I have a directory, which contains many files (more than a thousand), from different types (file extensions). I can sort them by Date modified, or by Type. But seems that I can't sort them by both ...
-1
votes
1answer
36 views

How to rename single-digit numbers to sort incrementally?

What is the simplest way to add 0's to all single-digit filenames to make them sort correctly? I'd like to stick to the command line if possible. From: a_1.png a_2.png a_10.png To: a_01.png ...
2
votes
1answer
114 views

Is it possible to sort a table by entry modification date? Specifically, how to access from VBA the last modification time of an object?

I have a MS Word document where I accumulate and frequently modify certain data in a very long table. So I would like to sort the data by latest modification time in the rows. Of course if I add a ...
1
vote
4answers
329 views

Is there a way to do Drag and Drap sorting of emails in Outlook?

I'd like to be able to manually sort emails in a particular Outlook folder instead of having it auto-sort by some particular column. Basically, for emails that I need to do some sort of follow up, I ...
0
votes
0answers
68 views

Change the sort order in Thunderbird on multiple columns

I would like to be able to sort (order by) email messages based on three (3) of the columns. Specifically at the top would be Starred, then Unread and then by Age (Newest at the top) (with Starred ...
0
votes
1answer
26 views

Sorting in Microsoft Excel

When I use the Sort "oldest to newest" in the Filter dropdown and I am sitting on, for example Row 400. After I do the sort my screen resets so I am sitting at the top of the spreadsheet instead of ...
2
votes
1answer
134 views

How to sort by senders' email address and not by display name in Outlook?

Is there a way in Outlook 2013 to view multiple incoming email addresses as the same contact? For example: Email #1 - Johnny Appleseed japple@yahoo.com Email #2 - JAppleseed japple@yahoo.com In the ...
13
votes
3answers
6k views

Sorting Excel column by IP address

I have a fairly large (over 200 row) Excel spreadsheet that lists items in my network (i.e. printers, servers, workstations, network projectors, etc), and one of the first columns is the IP Address ...
0
votes
1answer
54 views

“ls -la | sort +0nr -2 +2d” , what does sort do here?

I hae seen this somewhere written: ls -la | sort +0nr -2 +2d What is sort doing here? What are these arguments.
1
vote
0answers
70 views

Is there a Unicode-aware LC_COLLATE sort order which respects punctuation?

As far as I can tell, setting the environment variable LC_COLLATE=en_US.utf8 changes four things compared to LC_COLLATE=c, regarding how programs like ls will sort files: Unicode characters are ...
0
votes
0answers
18 views

Sort mp3 files based on both name and album in windows explorer [duplicate]

Let's say I have a bunch of mp3 file, is it possible to sort them based on both name and album? in a way that I first see the file listing based on artist name and than within that it will be sorted ...
39
votes
1answer
31k 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 ...
3
votes
1answer
141 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 ...
0
votes
1answer
29 views

How to force sorting of my tag list?

My list of nested Evernote tags, after some careless tag creation and renaming, is no longer in alphabetical order. I know that if I remove each tag from its parent tag, and the re-add, it will be ...
0
votes
2answers
25 views

GNU sort file names with prefix and one or two digit

I would like to use GNU sort to have the file names from a find command sorted by the numbers in the name. The name of the file is "cycle" then the first number to sort by, then ".subset", then the ...
0
votes
1answer
11 views

Linux redirect output ro earlier agument

Is there a way to redirect output on Linux to a former argument. For example, sort file.txt > file.txt Would there be a way to avoid typing file.txt again?
50
votes
12answers
66k 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): ...
0
votes
0answers
27 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 ...
4
votes
1answer
224 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) ...
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
25 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
55 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 ...