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

learn more… | top users | synonyms (1)

-1
votes
2answers
135 views

Recomposing data structure

I've a worksheet of 35k rows of the kind in the first table below that I want to reshape as in the lower table. So, I want to reshape this data in a way to get all the people within a specific ...
7
votes
4answers
4k views

Sorting numerically in a comma-delimited file with Unix

I've got a comma-separated file that looks like this: 100,00869184 6492,8361 1234,31 200,04071 I want to use sort to sort this file numerically by the first column only. Desired Result: ...
2
votes
1answer
3k views

How to order a numbered list in descending order?

When using a numbered list in Word, how can I have it order in descending order (ie. 10., 9., 8., 7., ...) ?
3
votes
2answers
930 views

Increasing productivity with huge Outlook Inbox - “Sorted Inbox” and frequencies

I am using Exchange Online and Outlook 2010 with a very high email volume and a big Inbox. I am already using colored categories and filtering of distribution lists into special folders. I am also ...
1
vote
1answer
431 views

Automatic sort for excel worksheet

I want to create a to-do list in Excel that automatically sorts the to-do entries in a list, in order of ones to do first (closest deadlines). I would also like a section that shows the tasks for ...
3
votes
0answers
594 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? ...
2
votes
2answers
398 views

How to get GNU emacs buffers sorted alphabetically?

Somehow, I caused my GNU emacs v23.1.1 list-buffers to be sorted alphabetically through some key sequence or mouse click I typed by error. How can I restore the normal order of buffers listed in ...
1
vote
1answer
999 views

Sorting two non-adjacent columns without affecting any other column

I have two different columns on Excel. I want to create a script that will sort Column F, (Have a header) and will sort Column B based on where Column F's sort worked out. (Without affecting any ...
1
vote
1answer
451 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 ...
5
votes
2answers
245 views

How do I expand columns of items in Excel so that each item is on its own line?

I have this: -----A-----|-----B-----|-----C----- 1|cherry |apple |banana 2|kiwi |banana |cantaloupe 3|peach |grape |peach 4| |peach |watermelon 5| ...
0
votes
1answer
232 views

gnu sort alphanumerically by one column, followed by numerically in next column?

How can I sort a text file with GNU sort starting with alphanumeric sort by one column, followed by numerical sort in the next column? I tried sort -n -k1,2 file.txt, but it doesn't seem to work: ...
2
votes
1answer
3k 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 | | ...
1
vote
1answer
143 views

sorting a file by column, possible values are number, Inf, -Inf, NA

I have a tab-separated ASCII file. One of the columns contains numbers which always have a decimal point (like 0.311225363556077). However, in this column entries might also be any one of these ...
3
votes
2answers
531 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 ...
0
votes
0answers
27 views

OS X Lion Finder and Open/Save sheets: How to list folders before files? [duplicate]

Possible Duplicate: How do you sort files in OS X Finder so folders appear at the top? I'm a recent Mac convert, but I miss the way Windows and many Unix file browsers list folders before ...
0
votes
1answer
244 views

How to sort pictures by name with some program?

You all know it - you have pictures from vacation and other life events and you decide that you will sort photos you want them to be as you wish together. My question is related to this. How can I ...
2
votes
4answers
15k views

Lotus notes 8.5 Inbox return to default sort and select next unread email

My default Lotus Notes (v 8.5.2FP2) Inbox is sorted by date/time (newest at top). I can then do the following steps: select a message (single click to select) click the 'Who' header: the sort order ...
0
votes
1answer
780 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
70 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 ...
2
votes
1answer
2k 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
3k 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
728 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
516 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
725 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
490 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
179 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
609 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
204 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
257 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
485 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
571 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
195 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
130 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
554 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
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 ...
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
157 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
798 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
95 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
25k 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
926 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
554 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 ...
12
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 ...