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

learn more… | top users | synonyms (1)

4
votes
2answers
323 views

Linux command line / Move files filtered by lexicographic order

I have some files in a directory that are named IMG_0001.jpg ... IMG_9999.jpg. I want to move to another directory the files that lexicographically have a name greater than IMG_9431.jpg How can I do ...
6
votes
1answer
124 views

List of files under a directory in name order

I wanted a list of files under a directory in name order to pass to an image viewer. I am using find $PHOTODIR -iname "*.jpg". Unfortunately this produces the images out of order. On a USB key ...
4
votes
2answers
76 views

Sort files with grep

I have a few hundreds of output files, of which some contain error messages. Lets say I want to automatically put all files containing the string "ERROR_1" in a "subfolder_1", and the rest in a second ...
3
votes
2answers
793 views

Excel: searching for a maximum lower than X

From the sorted list of values, I'm looking for a maximum that is lower than X Example: A B C 1 1 X=7 2 3 3 5 4 8 ANS=5 Do you have any smart ideas for this problem?
1
vote
2answers
273 views

How can I sort and de-dupe a very long list of words?

I have a 400 megabyte file. The file is a list of words, each word on a single line. End of lines are a mix of cr/lf and lf. Some of the words are unicode. I'd prefer answers for Linux or Windows ...
2
votes
0answers
197 views

How to sort Google Drive search results by title?

I find Google Drive very convenient as an online notebook to store my diary and records, that I can access anytime, anywhere. Now when I want to search for a particular string of text, the only ...
1
vote
0answers
40 views

Reordering file lines like other file (Unix)

Is there a tool (or option for sort) which will re-order lines of a file so that they are ordered like a key in another file? For example, I have a data file: T01F01475558 30 T01F022B3A17 31 ...
-1
votes
1answer
71 views

Explorer sort order by date (not by type) [closed]

Why Explorer in Windows 7 keeps grouping files by type when I want them by date? Each group is sorted by date (modified), but I would like all files sorted by date (mixed types, like an old'n'good ...
2
votes
1answer
397 views

Sort lexicographically in bash

I want data to be sorted in the way Python sorts it, comparing ASCII values. But sort command seems too clever for that. Take a look. Since '.' < '9': $ sort . 9 ^D . 9 $ sort 1. 19 ^D 1. 19 ...
1
vote
2answers
256 views

Sort by multiple columns in Windows Explorer 8

I have a directory, which contains many files (more than a thousand), from different types (file extensions). I can sort them by Date modified, or by Type. But seems that I can't sort them by both ...
2
votes
1answer
1k views

Pivot table : absolute value of grand total in Excel

My grant total is generated by summing values of COLUMNS of ITEMS for a given SUBJECT (For each SUBJECT I have a list of ITEMS and I want to make a grand total of the values of these ITEMS). The ...
0
votes
1answer
515 views

sort tab delimited text fields involving spaces

I am having difficulty with the Unix sort command when tab delimited fields are introduced. If a file test.txt contains: Hello (2) Hello (1) Hello applying a sort: sort test.txt produces the ...
-4
votes
1answer
586 views

Find n rows in spreadsheet with lowest values in one column [closed]

There are two columns, say, A & B. Total 50 numbers are inserted in Column A; i.e., A1..A50 (numbers can be same like 20 can come more than one time or up to 50 nos.). In front of every row of A1 ...
2
votes
2answers
176 views

Why is sort.exe truncating large output on 32-bit Windows?

We have a data file from a client which is 1,443,777,659 bytes in size. Sorted output has lines missing and is only 1,269,801,985 bytes in size. Sample command: sort -k 1,10 -T . -s -i ...
13
votes
3answers
5k views

Sorting Excel column by IP address

I have a fairly large (over 200 row) Excel spreadsheet that lists items in my network (i.e. printers, servers, workstations, network projectors, etc), and one of the first columns is the IP Address ...
0
votes
1answer
393 views

Changing default sort order in Windows 7 desktop search

If I do a search (usually, I'm looking for an email), the results are presented in date-modified order by default I can do Sort By / More... and select Date Received, then Sort By and select Date ...
0
votes
1answer
62 views

how to delete a file after sorting in Linux

I have a huge file that needs to be sorted in Linux, for example: sort -k1,1 -k2,2n /dir/fileA.sam > /dir/fileA_sorted.sam Because I ran out of disk space, is there a way to delete the original ...
0
votes
2answers
7k views

Is there a dynamic sorting feature in Excel 2007/2010?

I have a task list spreadsheet that I maintain. Each task is given a ranking based on number of days until due date, weighted by high, low, or medium priority. The ranking is automatically calculated, ...
1
vote
2answers
11k views

In Excel, How to sort a column and keep respective values in other columns

How do I sort a column according to ascending values in excel, while keeping the respective initial value in the other columns on the same row? Column A shows the name of a subject. Column B shows a ...
3
votes
1answer
339 views

Remember icon size, sort order, and sort options per-folder on Windows 7

Sometimes when I change the icon size in one folder, all other folders are changed, too. Sometimes they are unchanged: Sometimes when I change the sort order, all other folders change too, ...
0
votes
1answer
108 views

Excel rearrange data and sort

i have a table in excel with data in this format (with alot more data): date source data1 data2 1.2.3 1 767 888 1.2.3 2 543 444 2.2.3 1 557 333 2.2.3 3 576 777 It ...
1
vote
2answers
1k views

How can I sort a long list of text alphabetically?

How do I sort rows of text alphabetically without using specialized third party software or plugins (like Notepad++/Word/Excel/et al)? I suppose what I'm perhaps asking is -- How do I sort rows of ...
0
votes
1answer
550 views

How can I permanently divide / separate files, folders, and shortcuts on Windows 7 desktop? [duplicate]

Basically I want to devote a flexible, visibly divided fraction of my screen to each type of icon visible on the Desktop (files, folders, shortcuts). What will I (or someone much more skilled than I ...
2
votes
3answers
377 views

weird filename sorting (bash, ls, sort)

Good day, everyone. I'm trying to feed my music to mplayer, like this: mplayer *, but getting wrong track order. Here's what I get with ls (as well as ls -1, ls -1 | sort), note the order of the ...
0
votes
1answer
80 views

How to sort an Excel column using the following characters

I have a column with letters W and E following numbers, i.e. 4e 5w 6w 7e 7e , and I want to sort the column into e and w. Any help would be appreciated.
1
vote
2answers
286 views

How to manually sort files in win explorer?

I want to manually sort (drag and drop) my files in a certain (not in all) folders (win xp sp3). Is there any fix to do it ? If no - is there another file explorer with the feature.
6
votes
4answers
2k views

I need an easy way to 'google' through all my PDF files - anything like this exist? [duplicate]

Here is my scenario and system: System: Win-7, 64-bit. Scenario: Very simply, I have a folder on my dropbox account, titled \Papers. Within this folder, I have a lot of PDF files, and I have even ...
0
votes
1answer
88 views

Correct sorting after text to columns in EXCEL

I have some data in which one column represents the Days of Operations, as below: ------- Days ------- 15 7 1234567 etc. I want to "break" the column (via text to columns option in the Data tab of ...
2
votes
1answer
355 views

Vim - sort blocks of code within blocks

Note: Can someone with 300 reputation please add the tag, "scss" to this question? I'd be very appreciative. My code (scss): .cinderblock { @include minwidth(); ...
0
votes
1answer
3k views

How can I sort a list of numbers, by its last 3 digits in Excel

I have an Excel spreadsheet with a list of numbers in the first column (that is: I have a number in A_1,A_2,...). Each one of the nubers if have 8-9 digits and I would like to sort this column by its ...
-4
votes
4answers
4k views

Finding values that only appear once in column

I have 4 columns and ~10K rows. I wonder whether it is possible to extract the rows where the value in column (A in my case) occurs only once. I don't want to filter out the duplicates, just the ...
0
votes
2answers
808 views

Why do I get an #REF! error after sorting?

In my workbook I use this formula: =INDEX('G:\Manufacturing\WH\EXPORTS\Scanning_Reports [ScanningReport.xls]Sheet1'!$D$1:$D$65536;AB3) It works fine but when i try to sort the data i got a #ref! ...
1
vote
1answer
586 views

How to sort folders by last characters of folder name in Windows 7?

I have a stack of client folders with names like this: eastcoal 008 mee 022 orr 047 owaka 032 owen 025 powernet006 redpath 031 Normally this works, but sometimes I'd like to sort by the number. ...
1
vote
1answer
316 views

Office 2007: How to sort an Excel Table from within a Word macro

I have written a Macro in WinWord2007 which lists styles and their properties in an Excel table. The table is made accessible by the following 3 lines: Dim Oxl_Sheet As Object Set Oxl_Sheet = ...
0
votes
1answer
1k views

UNIX command to sort the file by the following words, from major sort key to minor sort key: word 3, word 1, word 4

Need help with the UNIX command below to sort the file by the following words, from major sort key to minor sort key: word 3, word 1, word 4. (words are separated by white spaces) sort -t -k3 -k1 ...
1
vote
2answers
420 views

How can rearrange my columns to rows in Excel?

It is a bit complicated to describe in words, but I am making a literature review and I need to map how often certain theories are used within certain themes or topics. I currently have a table like ...
4
votes
2answers
2k views

How to sort Windows 7 taskbar thumbnail previews?

Here is a screenshot of the list of windows I have stacked in my Windows 7 taskbar. This is just for Explorer, but similarly I have lots of stacked windows of other processes as well. Currently ...
-1
votes
1answer
829 views

(Some Program that lets me) Manually Sort Folders in Windows 7

I want to have some convenient way of remembering the order I put certain folders in, without being forced to rename them. Some of these folders may get deleted and new folders also get added, so ...
1
vote
1answer
284 views

Make Excel Row Height Stay when Sorted

I have an Excel 2007 spreadsheet and need to make some rows bigger than others so there is vertical space for a signature. These cells are colored differently, but the height doesn't stick with the ...
1
vote
1answer
623 views

How to view all my Google Chrome bookmarks, sorted by date?

I want to see a flat list of all my bookmarks in Google Chrome, sorted from the oldest one to the newest one. How can I achieve this ?
3
votes
2answers
440 views

how can I sort duplicate values in excel without repeated it sequence

i want the excel sort the values A to Z first then take the duplicate values to sort it again below A to Z like the following: if i have the values a,c,b,e,d,a,c when i sort it a to z it's look like ...
1
vote
2answers
92 views

sort numbers in excel10

this is a sample of my movie list as you can see 61 is at the top and 8mm at the bottom please explain how i can have 1 at the top and 3000 at bottom 61 .45 2006 dvd 10 1979 dvd 10 items or less 2006 ...
2
votes
1answer
344 views

How to output a partial or a number from a mataching in grep or ack

I have a text file demo.txt like below. This is a line with id (9) This (8) is another line with id (10) This is a line with id too 11 This line does nothing The file has some lines with id ...
1
vote
2answers
6k views

How to sort audiobook on iTunes?

I have a question that might seem dumb, but I didn't find anything on Google. How can I do to sort my audiobook tracks on iTunes? I have books with 4 or 5 CDs and I'd like them to appear as one. I ...
1
vote
1answer
1k views

Sorting by Date Modified in Windows 8

In prior versions of Windows I used to be able to sort my folders by date modified. If any files in those folders where added, removed, changed etc... the folder date would be updated. However, in ...
0
votes
1answer
178 views

Sort files based on their meta-data

At a local storage (ext3/ext4) I have thousands of files of various types. I need to sort them, however I can come up with the criteria to do so as long as it's possible to get an overview again. I ...
1
vote
1answer
243 views

Sort columns next to last column in Linux

I have multiple files: File 1 a 1 2 b 3 2 File 2 a 2 2 3 b 4 3 3 File 3 d 3 1 2 4 e 4 1 1 2 I'd like to sort the files according to the column next to the last column, after sort: File 1 ...
0
votes
2answers
92 views

How to add another sort tab for files in Windows?

I am working with a directory of PDFs which have been scanned from actual documents in a file cabnet. When viewing a folder's contents in windows by clicking the tabs above the information users are ...
0
votes
1answer
503 views

sort du -sh by size in human readable

with the command du -sh * I get the summary of files in MB,GB, etc. If I use du -s * | sort -nk1 I get the summary sort by size. How I can get the summary sort by size in MB, GB, etc? Edit the ...
5
votes
1answer
177 views

Merge sorted lists

I have a few .txt files (in the same directory) that look like this: 123 carrot 50 apple 13 tomato 5 potato 2 pear and 100 carrot 10 apple 3 tomato 2 potato ...