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

learn more… | top users | synonyms (1)

0
votes
1answer
637 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
2answers
68 views

How to search for and sort all lines found using vim?

I have some c++ includes that I want to sort: #ifndef t #define t #include <b> #include <a> #include <c> #endif I can shift-v to highlight the #include lines and then do :sort ...
1
vote
1answer
1k views

How can I sort objects by third column in Powershell?

I've a text file like this: 4108689096 2531 ./ssss/132432.odt 481446057 2293 ./abc/a.txt 3157353085 1096 ./dsjvbjf/c.docx 653380669 1824 ./bcd/x.avi And I'd like to achieve in Powershell to sort ...
3
votes
2answers
2k 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 ...
1
vote
1answer
627 views

Set collation order in shell sort to not ignore special characters

I am looking for a solution for sorting in postgres but it seems to be more of a problem of collation and therefore I ask the question for the standard Unix sort command instead. I have the following ...
0
votes
1answer
487 views

Solaris + sorting file according to date and time by sort command

I have along list that created in /var/tmp/file.txt from some script (in Solaris machine) the following list have 4 fields please advice how to sort the list according to the following TIMESTAMP ( by ...
0
votes
3answers
566 views

What ascii character would sort before the dot character?

In Midnight Commander, files beginning with dot (hidden files) are sorted first and this make browsing in home directory quite difficult. Is there a character that I can use that would be sorted ...
0
votes
5answers
1k views

Using find command to list top 5 image files by size

All, I want to list the top 5 image files (png,jpg) in a given folder.What's the best approach? I'm using the following currently but it doesn't give the right output: find . \( -iname \*.png -o ...
-2
votes
3answers
96 views

What should I consider when deciding on how to manage huge personal data? [closed]

I have huge data which contains images, pdf files, application installers and other utility software's with around 600 GB movie collection. I would like to take suggestion how I can sort the same so ...
4
votes
2answers
450 views

Custom metadata fields in Windows file manager (or other software)

I'm trying to organize a collection of maybe 500 or so journal articles, stored in a combination of .pdf and .djvu formats. I'd like to be able to sort the collection by author(s), title, journal ...
0
votes
1answer
177 views

How do I sort in Excel 2007 but do not go to the top of the list?

How do I sort in Excel 2007 but do not go to the top of the list? I have a filtered set of data many rows long. However, when I am deep in the list, and select to change the sort by method on one of ...
3
votes
1answer
487 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
193 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
235 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
426 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
542 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 ...
1
vote
2answers
2k views

Looking for batch automation program to reorganize/move/sort files into a new folder/directory structure based on file name content (Windows)

I have music files that already have artist name and title in the file name. However the files are currently not well organised in folders. I don't require audio-fingerprinting. Is there a program ...
4
votes
2answers
1k views

How to physically reorder files `03.mp3 01.mp3 02.mp3` (`ls -f`) in a directory?

The physical order of the files matters when I copy them onto my USB stick and listen in car mp3 player. Most of my music album folders are unsorted, e.g. ls -f may produce: 03.song3.mp3 01.song1.mp3 ...
2
votes
1answer
189 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
126 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
494 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
389 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 ...
6
votes
1answer
1k 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
154 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
1k 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
721 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
92 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, ...
1
vote
2answers
21k 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
33 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
2k 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
823 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
414 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 ...
11
votes
1answer
4k 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
2k 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 ...
0
votes
1answer
1k views

Windows 7 : Sorting contents of a file

Is there any functionality by which I can sort the contents of a file in place in windows 7 ? I am not sure if there is any way I could do it in UI, but is there any batch script which will help me ...
10
votes
2answers
6k 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
4k 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
96 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 ...
10
votes
1answer
15k 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
2k 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
420 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
960 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
329 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, ...
0
votes
3answers
6k 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
719 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
1k 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
1k 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
72 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 ...