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

learn more… | top users | synonyms (1)

3
votes
1answer
769 views

Sorting files based on a timestamp within the file

I have a bunch of files which contain an ascii header with a time stamp WITHIN the file, followed by a large chunck of binary data. I would like to list the files sorted by this time stamp, at the ...
1
vote
1answer
225 views

gnu sort/uniq: sorting by number of times

How can I use GNU sort and uniq to have the most common occurrences on top instead of numerical or alphanumerical sorting? Example list.txt: 1 2 2 2 3 3 Since '2' occurs 3 times, should be on top, ...
2
votes
1answer
290 views

Sorting a checksums file by file name

I'm trying to sort the output of the md5sum program by file name, numerically (that is, file names all match log-\d+\.txt). I tried sort -g "-t " -k 2 CHECKSUMS but it sorts by checksum. Using ...
0
votes
1answer
590 views

Sorting Outlook calendar All Appointments view by next appointment date

I like the All Appointments view in the Outlook [2007] calendar, but I can't figure out how to get it sorted by the next appointment date. Put another way, I'd like to see the nearest-in-time ...
1
vote
1answer
608 views

Prevent sort by name from sorting descending order in windows 7

It seems in Windows 7 (and most likely Vista as well) when you right click on the desktop, it'll sort by name in ascending order. If you right click and sort again, it will sort in descending order. ...
2
votes
1answer
2k views

Sort Numerically in OO Calc functions alphabetically

Using Open Office 3.3.0 Calc will sort a list of numbers not in numerical fashion, as would seem reasonable, logical, and rational, but in alphabetical order. Eg: Calc thinks that 103,1000,etc come ...
2
votes
1answer
199 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 ...
0
votes
1answer
131 views

How to sort so that caml is after c in an xml?

Sorting a file with lines <LexerType name="caml" desc="Caml" ext=""> <LexerType name="c" desc="C" ext=""> causes caml to be before c, how do I put c first in general, without relying on ...
0
votes
1answer
603 views

Filter rows with unique values on Microsoft Excel

I have got a set of rows in an microsoft-excel column_a column_b column_c column_d column_e r1 200 300 350 400 3 r2 200 ...
3
votes
2answers
491 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 ...
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 ...
0
votes
1answer
158 views

Use Excel to select the most recent row from a CSV?

I have a CSV that starts with a date/time field and I need to import, and select the most recent row and refer to it in my formulas. I'm experimenting with Pivot Tables, and just now Rank and ...
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 ...
5
votes
2answers
883 views

ls version number sorting Mac OS X

Is there an equivalent to ls -v in Mac OS X that will do version number sorting? In Mac OS X, ls -v does NOT do version number sorting, but the Finder seems to.
0
votes
1answer
96 views

Excel - Sort by x - 0000xx000000

I have a list in Excel that i need to sort. But i need to sort on number xx in the following format: 1234xx123456 3541xx548135 So if xx in the first row is 68, and the xx in the second row is 45, ...
2
votes
2answers
31k views

Excel Sort Numeric Column By Number

I have a column of integers in my spreadsheet, and the column is formatted as a number. Each cell inside the column is formatted as a number. But I can't seem to sort them in numerical order - you ...
0
votes
1answer
36 views

Sort xdebug output

I have a xdebug function trace output that looks like this: 1130.8156 482236096 -160 -> memory_get_usage() 1130.8156 482236112 +16 -> X 1130.8157 ...
0
votes
0answers
61 views

Sorting a list of directories that contain numbers with a different number of digits [duplicate]

Possible Duplicate: In bash, how to sort strings with numbers in them? We have the following directory structure on our file-system: ver30 ver20 ver50 ver70 ver100 ver90 I want to create ...
1
vote
3answers
3k views

Advanced sorting in excel

I have a data in excel in the format: Description Name Percent Always A 52 Sometimes A 23 Usually A 25 ...
1
vote
2answers
1k views

How to copy lines in Excel file that contain a value from a list

Description I have a CSV file with 6000+ lines in it. I have a list of about 300 words that each appear in only one row of the CSV file. Problem How do I extract only the rows that contain a word ...
3
votes
1answer
853 views

Sorting XML files so that differences can then be found

I need to compare two XML files, each of which is about 13,000 lines long. Sadly the code that generates these files doesn't generate the data in the same order each time (the data comes from a ...
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 ...
4
votes
3answers
3k views

How to sort list-style numbers in Excel?

I have a column of "numbers" in Excel that I would like to sort as follows: 1.1 1.2 1.2.1 1.2.6 1.2.9 1.2.10 1.2.11 1.3 However, regardless if the cell's type is number or text, Excel sorts them as ...
10
votes
2answers
7k 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 ...
1
vote
1answer
5k views

Can I use unix sort to sort a file on multiple keys of different types (mix of strings and numbers)?

I have a delimited text file of multiple columns some of which are text and some of which are numbers. I would like to sort on multiple fields, wich span both text and numerical fields. While -n ...
0
votes
1answer
108 views

Does any OS/app/library support Roman numerals in natural numeric sort?

In modern operating systems, a list of files named 1.jpg through 10.jpg is sorted with 10.jpg appearing after 9.jpg, as it should. But I don't know of any natural sort implementation that accounts for ...
13
votes
1answer
24k views

How to sort an Excel spreadsheet columns by row contents?

How do I sort the columns of an Excel spreadsheet? The Sort command from the Data menu only allows me to sort rows by the value of a column. I want to sort the columns alphabetically by the contents ...
1
vote
3answers
3k views

How to sort on hh:mm:ss (duration) in Excel

I have a column of data that represents duration, e.g. 33:15 - 30 minutes and 15 seconds; 1:05:00 - 1 hour and 5 minutes, etc. If I try to sort it A-Z, then 1 hour gets sorted before 30 minutes. Is ...
3
votes
1answer
511 views

sort by word length in Nth column

I've got a column file like this: 1 1 1 AKSDFJADFKASDJFAK 2 1 1 ADKLCJASDLKCJDLACKADCJLKDACJADS 3 1 2 AKLJDFHALKDJFHLKJSDKSDFHAKJFDHAKFHJAKFJ And I would like to sort the entries by the fourth ...
1
vote
1answer
1k views

batch-rename filenames with numbers to sort alphabetically

I want to batch-rename files containing numbers, padding the numbers with zeroes. The goal is to sort numbered sets of files alphabetically in the correct order in any application. In a set of files ...
1
vote
2answers
448 views

Excel: Remove lines with duplicates in column B, based on data in Column A

I need to find duplicates in Column B; and then delete the entire line if the the value in Column A is the number 4. There are lines that need to be kept and have "4" in Column A. A B 1, John 4, ...
1
vote
3answers
10k 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 ...
3
votes
2answers
850 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 ...
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
3answers
2k views

Linux sort all data in memory

For Linux command sort, how do I force sort to load all input into memory and sort assuming I have enough memory? Or is it best to use a RAMDISK to store the input before feeding it to sort?
1
vote
1answer
75 views

Can excel organize my data into groupings?

First off, my data sample: EZ LOADER 1 FAIRMONT MOBI 1 FARMALL TRACT 3 FORD 5 FORD 700 1 FORD F-150 1 FOUR DOO 1 FOUR WINNS 1 GENERAL 3 GENERAL ...
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): ...
4
votes
1answer
223 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) ...
1
vote
1answer
1k views

How do I arrange my desktop icons in rigidly alphabetical order?

Currently, my desktop icons are divided into three groups: Upper left icons in the following order: Libraries Computer Recycle Bin Network Magic Continuing to read downwards and to the right: ...
1
vote
2answers
562 views

Sort multiple files with bash

I have a question that involves the bash scripting language. I have multiple directories /studentName /studentMail /studentNumber In each of these directories is a file name.txt, mail.txt, ...
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 ...
5
votes
1answer
1k views

Get Windows 7 to Stop Grouping Search Results by Immediate Parent Folder

Searching in Windows 7 is frustrating, inconsistent, and too different from in XP. One of the most egregious problems is that it insists on grouping search results by the immediate parent of items. ...
0
votes
2answers
515 views

Pull up Excel's Sort Dialog

I have to sort a protected sheet and need to perform the unprotect-sort-protect dance. The problem is this way I'm duplicating (less than perfectly) Excel's own sorting functionality, with the ...
1
vote
1answer
515 views

order for loop output command prompt

I'm using the following command to list some of my favorite videos in a directory (and redirect the output into a text file): for %i in (*avi *.mkv *mp4) do @echo %~ni I'd like to alphabetically ...
1
vote
1answer
278 views

How do I re-sort a list of files grouped by directory?

From within a DOS batch file, how can I crudely re-sort a text file containing a manually maintained list of source files, so those files listed (from the same directory) in the small example extract ...
0
votes
1answer
1k views

GNU sort and git blame

Today I thought I was doing a simple operation: git blame file | sort -k 3 To get all the lines of file sorted by the date on which they were last changed. Unfortunately it doesn't seem to be ...
4
votes
3answers
2k views

Firefox does not sort bookmarks automatically

Whenever I add a site to my bookmarks, Firefox puts it at the end of the list. In order to sort my bookmarks by name, I have to right click on the relevant folder and select "Sort by Name". Is there ...
1
vote
1answer
5k views

How do I count the times each number appears in columns of numbers?

I am sure this must be easy, but I am inexperienced. About the best way to think of my problem is to think of it as trying to sort and then count lottery numbers. To stay simple, let's do a Pick 3 ...
2
votes
2answers
783 views

Sorting a REALLY BIG delimited text file in UNIX / VMS

I am going to sort a REALLY BIG delimited text file, say 250Mb (or a bunch of files of more or less than 250Mb) . It have 37 fields, and I need to sort it by 5 fields, for example 1st, 4th, 5th, 6th ...
0
votes
1answer
805 views

Win7: sort icons in “desktop” popup/toolbar

I've right clicked my task bar and selected Desktop in the Toolbars submenu. This now shows a Desktop >> button left to the tray area. When I click this button, a popup with my desktop icons opens ...