The sorting tag has no wiki summary.
2
votes
1answer
24 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
42 views
Lookup and return value based on sub-string match
Is there a formula or script that will match sub-strings from one column in another column and return the full value of the sub-string match? e.g.
Input
COL_a COL_b
name ...
1
vote
1answer
19 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, ...
1
vote
1answer
53 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
22 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 ...
0
votes
1answer
58 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. ...
0
votes
0answers
9 views
Show oldest when clicking on Outlook conversation?
Question:
How can I make Outlook 2010 always select the oldest unread message in a conversation when expanding it?
Details:
Outlook 2010 inbox is configured to "Show as Conversations" (w/ "Always ...
1
vote
1answer
94 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 ...
0
votes
1answer
98 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 ...
3
votes
1answer
90 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
133 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
74 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
37 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 ...
2
votes
1answer
68 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 ...
4
votes
1answer
72 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
45 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 ...
0
votes
1answer
131 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 ...
0
votes
1answer
37 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, ...
0
votes
2answers
134 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
0answers
22 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
54 views
Sorting a list of directories that contain numbers with a different number of digits [closed]
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 ...
0
votes
3answers
114 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
66 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 ...
1
vote
0answers
52 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 ...
1
vote
1answer
83 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 ...
2
votes
2answers
125 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
32 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 ...
2
votes
1answer
513 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 ...
0
votes
1answer
20 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 ...
7
votes
1answer
95 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 ...
0
votes
3answers
113 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 ...
1
vote
1answer
58 views
Thunderbird 3 message sorting order
Possible Duplicate:
Change the default sorting order in Thunderbird
I like my mails to be sorted by date, with the newest at the top and the oldest at the bottom. However, I prefer unread ...
3
votes
1answer
66 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
210 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
41 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
110 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 ...
2
votes
2answers
94 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
40 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
114 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
43 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 ...
2
votes
4answers
1k views
Unix/Linux find and sort by date modified
so I was wondering how I could do a simple find which would order the results by most recently modified. Here is the current fine I am using.
(I am doing a shell escape in php, so that is the ...
2
votes
0answers
56 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
97 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
136 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, ...
5
votes
1answer
426 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 ...
2
votes
1answer
220 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
97 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
118 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
179 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 ...
3
votes
2answers
313 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 ...