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

learn more… | top users | synonyms (1)

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 ...
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
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
101 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
18k 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
450 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
376 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
7k 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
755 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
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
73 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 ...
44
votes
12answers
54k 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): ...
3
votes
0answers
208 views

Is there a way to keep the selection in Windows 2008 Explorer when changing the sort order

I 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
509 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
1answer
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 ...
4
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
457 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
445 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
261 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
4k 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
726 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
737 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 ...
4
votes
2answers
1k views

unix sort algorithm implementation

What sorting algorithm(s) is/are used in the unix sort command? Insertion/quicksort/etc.?
2
votes
1answer
758 views

Two Spreadsheets, Merge Data?

I was wondering what is the best way to merge two spreadsheets which have the name id's e.g: One sheet has: apple 5 dog 3 cat 2 Second sheet: dog 4 apple 7 cat 3 I would ...
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 ...
0
votes
1answer
458 views

Can I sort files A-Z and at the same time Z-A?

Question I am trying to sort and rename a large number of files that are labeled #####_## The LEFT side of the underscore are numbers (e.g., 32956715, 32956810, etc.) that do not repeat. The RIGHT ...
7
votes
2answers
477 views

In utf-8 collation, why 11- is less then 1-?

I found that the sort result in ASCII: Source file test: 1- 11- 1-a 11-a Sort using ASCII: $ LANG=en_US.ascii sort test 1- 1-a 11- 11-a And using UTF-8: $ LANG=en_US.utf8 sort test 1- 11- ...
7
votes
3answers
2k views

Why does 'sort' ignore special characters, like the asterisk?

I thought that sort would sort common prefixes together but that doesn't always happen. Take this input for example: AT0S*eightieths AT0S*eyetooth's AT*ad AT*Ad AT*AD AT*Eydie AT*eyed ATF*adv ATF*ATV ...
0
votes
1answer
745 views

is there a way to sort and rename open windows in Windows XP taskbar?

I want to rename and if possible sort my open Windows in the task bar. The reason is that some programs I use (pgAdmin, Windows Explorer, Google Chrome) put names on the Windows from which I cannot ...
1
vote
1answer
460 views

Sort text file of blocks

There are plenty of tools that will sort a text file on the assumption that the unit of interest is the line, but are there any that work on blocks? Example: name = Mercury order = 1 mass = 0.06 ...
2
votes
1answer
1k views

specify the sort order in “copy /b *.dat foo” in Windows cmd

Normally, when I do a copy /b *.data foo in Windows cmd, the *.data files are catenated in the sorted order into the destination file foo. This matches my desired behavior. However, I just met a ...
0
votes
1answer
3k views

Excel / VBscript: Need to sort columns with a header

I have a vbsctipt that opens an Excel(2007) document copies the used range from two sheets (minus the header on sheet 2) puts it all on 3rd sheet. I then need to sort that data using the header. I ...
0
votes
1answer
1k views

Autosort microsoft excel worksheet

Can I configure (possibly with scripts) Excel to automatically resort a table every time an entry is updated?
0
votes
3answers
1k 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 , ...
3
votes
2answers
4k views

How to sort ls by column in Ubuntu via piping to sort?

I'm a Linux newbie trying to learn how piping works in the Ubuntu terminal. I tried to sort by file size: ls -al | sort -k5 The files were listed in this order: drwx------ 19 min10 domain users ...
0
votes
1answer
467 views

Windows 7: View column headers in Windows Explorer when in icon view

In windows 7 is there a way to view the column headers in Windows Explorer when you are in icon view? When in details view you get a list of column headers that makes it easy to filter or sort by ...
4
votes
4answers
1k views

Windows explorer: sort by date modified

Is it possible to properly view the contents of a folder sorted by modification date in Windows explorer (Windows 7)? I can sort by the date modified column, but folders and files are seperated. I ...
1
vote
0answers
602 views

Path Finder: How to sort files by date, but folders by name?

This is possible in Total Commander. How can I make such separate sorting in Path Finder as well? I like to sort files by date, but I don't see any point in sorting folders this way - they just jump ...
6
votes
6answers
9k 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 ...
5
votes
2answers
5k views

Sort order “Other Calendars” in Outlook

If I open a Shared Calendar in Outlook, it will be added in the "Other Calendars" section. Unfortunately Outlook doesn't sort them by Name. Is there a way/hack to sort them alphabetically?
0
votes
4answers
286 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 ...
8
votes
3answers
10k views

fatsort for Windows 7 [closed]

I've used a program in Linux called fatsort to reorder the directories on my USB flash drive so that my car stereo navigates folders in alphabetical order instead of random order. Is there any ...
1
vote
3answers
704 views

Why does my exchange message filtering rule not work?

I have two rules set up to sort incoming bug reports. The first is specific to a single device: Apply this rule after the message arrives sent to SMS Distribution and with ...
0
votes
1answer
36 views

Is there a blog tool with support for tagging posts, only displaying posts with certain combinations of tags, and LaTeX? [closed]

What I want: A blog. I can tag posts, e.g. "A" or "B" or "all," and then you can either 1) click to only view posts tagged "A" or "all" or 2) even more ideally, I can set it so you automatically see ...