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

learn more… | top users | synonyms (1)

12
votes
4answers
8k views

Windows 7, any way to sort folders and files all mixed together?

Is there a way to sort folders and files by their name all mixed together in Windows 7? It would be easier to understand if you look at this page. I want my folders and files arranged like the ...
70
votes
13answers
100k 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): ...
8
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 ...
91
votes
1answer
78k views

Sorting lines in Notepad++ without the TextFx plugin

The current version of Notepad++ (at the time of this writing) is 6.6.3. Version 6.5.2 is the first that introduced a native (without a plugin) sorting function. At least, that's what they claim; even ...
3
votes
2answers
636 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
1answer
707 views

Microsoft Excel 2003 - Merge by Column

I'm trying to merge two excel files, here is the structure of the files: [A] [B] I want to add the column B from one file to another as column C, but the thing is that they have some rows under A ...
22
votes
7answers
26k 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 ...
14
votes
3answers
11k 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 ...
3
votes
3answers
1k 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 ...
57
votes
10answers
43k views

How to sort first directories then files etc… when using “ls” in Unix

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.
14
votes
1answer
6k 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 sort....
7
votes
1answer
2k views

How can I sort a folder in OS X Lion without having to group files as done with “Arrange By”?

I'm sorry to say there are several things I liked better in Snow Leopard. Sorting files in Finder is one of those things. If I "Arrange By" -> "None" it does not group items and it looks like 10.6. I ...
3
votes
2answers
4k views

Find all duplicate files by MD5 hash

I'm trying to find all duplicate files (based on MD5 hash) and ordered by file size. So far I have this: find . -type f -print0 | xargs -0 -I "{}" sh -c 'md5sum "{}" | cut -f1 -d " " | tr "\n" " "; ...
6
votes
1answer
3k views

Excel 2013, can data be re-sorted automatically?

Is there a way to re-sort automatically? I have automatically updating cells and depending on incoming values the rankings change. I am looking for a way to have the table resort automatically (...
6
votes
2answers
1k views

Sorting mail in Thunderbird by both unread status and by date

Is there any way to make Thunderbird sort mail so that unread mail is always at the top and the e-mails are sorted by date in descending order persistently? Maybe an add-on that someone can recommend? ...
4
votes
2answers
8k views

batch - File last modification time with seconds

I want to know when a file has been modified for the last time. I can get these infos using the following batch script: FOR %%i IN (myfile) DO SET modif_time=%%~ti The problem is that I need ...
3
votes
3answers
22k views

How do I line up two sets of data in Excel?

If I've got two sets of data, how can I line them up in Excel 2007? For example, if one set of data has Position Occurrences 8 3 11 1 17 ...
2
votes
0answers
114 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 ...
2
votes
4answers
3k views

Sorting files (images) and then renaming them automatically according to the sort

We want to sort image files in a directory and want them to renamed according to the order we gave. Is there a tool that can do this? (os: windows xp)
1
vote
1answer
2k views

What Windows app can sort a huge XML file?

I have some enormous XML-based configuration files, with 125000 lines in them. The problem is that they are auto-generated by the system I use, and "child" tags are in a random order within their ...
1
vote
1answer
1k 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. ...
5
votes
2answers
7k 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 ...
4
votes
2answers
1k 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 ...
4
votes
2answers
100 views

Is there an add-on for Excel to allow me to sort by an arbitrary column with a SINGLE click?

Windows Explorer allows you to sort by an column by clicking on the 'header' of that column so you can see files sorted by size or filename etc. Excel on the other hand forces you to go through the ...
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 ...
3
votes
2answers
4k views

Sort order in Windows Explorer

The behaviour described below occurs on Windows-7 systems and on Windows XP. We operate in a dual-language environment - English and Hebrew. When in Windows Explorer we sort files by name, the order ...
2
votes
1answer
224 views

Why is sort -k5nr not a syntax error?

$ ls -l | sort -k 5 -n -r $ ls -l | sort -k5nr I find out these two command generate the same output. But I don't understand why I can combine 5 with n? Why not a syntax error? edit: $ ls -l | cut ...
2
votes
1answer
5k views

Excel: How to treat multiple lines as one while sorting?

I get a XLS-File as a database report. The File is in the following format: | Customer | Name | ... | Orders 1 | 6 | ... | ... | 1234 2 | | | | 4567 3 | | ...
2
votes
1answer
3k views

Outlook 2003: How to group by flag AND sort by date?

I'm trying to get Outlook 2003 to do the following: Group the emails in my Inbox by FLAG and then sort by DATE. This SHOULD be accomplished by the following settings: It seems to work, as I get ...
1
vote
1answer
2k 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
1answer
135 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 ...
1
vote
2answers
1k views

Change how Explorer sorts files with number in name

In Windows 7 / Windows Server 2008, if files have only number in filename, Explorer sorts them by the number. How can I change this sort to trully alphabetic, ie.: 108 1110 188 439 455 etc.
0
votes
2answers
17k views

Is there a dynamic sorting feature in Excel 2007/2010?

I have a task list spreadsheet that I maintain. Each task is given a ranking based on number of days until due date, weighted by high, low, or medium priority. The ranking is automatically calculated, ...
0
votes
3answers
2k views

Sorting is not consistent using the Unix command 'sort'

I'm running the command: zcat [File] | sed "1d" | sort -t $'\xE7' -k [field to be sorted] > [file].sorted When I run this on File A, sorting on field 1, I get the following result: 11622400 , ...
0
votes
1answer
2k views

How do I add the “Date Created” sort-by option to the shell in Windows 7?

I know how to add it via the context menu, but it never seems to be a permanent option. I would like it to show in all folders without having to continually go back through and add it. How can I ...
0
votes
1answer
149 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 ...