The tag has no wiki summary.

learn more… | top users | synonyms (1)

4
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
148 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
651 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
90 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
18k 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
696 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
365 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 ...
10
votes
1answer
3k 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
847 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 ...
8
votes
1answer
5k 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
89 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
12k 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
1k 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
385 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
838 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
272 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
5k 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
639 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
924 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
927 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
70 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 ...
32
votes
9answers
40k 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
189 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
413 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
3k 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
971 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
375 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
343 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
237 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
812 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
1k 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
3k 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 ...
1
vote
1answer
448 views

How Windows arranges files by date

In Windows 7 if I have files arranged by date on the desktop with newest being last, then files are automatically places at the end (i.e. right bottom) as I update them. The exception seems to be ...
2
votes
2answers
644 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
634 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
673 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
1k 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
449 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 ...
6
votes
2answers
407 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- ...
5
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
671 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
388 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 ...