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

learn more… | top users | synonyms (1)

3
votes
3answers
159 views

Move dated files into their corresponding dated folders

I have .pdf files with the date at the end of their name, e.g. "BINNAWAY - WERRIS CK - 483.94 - 120612". I have folders named after the dates of each of these files e.g. "12-06-2012". How can I move ...
0
votes
3answers
53 views

Extract identical files from two directories

I am looking for a linux solution for the following problem: Given two directories with a large number of files. All file names are random and different in both directories. The contents of some of ...
2
votes
1answer
1k views

Is there a way around broken pipe?

I have a directory with a large number of files. ./I_am_a_dir_with_many_subdirs/ Within a script I'd like to find all subdirs in it, to sort them and to output to a bash array. So, I do: ...
0
votes
1answer
85 views

how to reverse the sort order of tabs in firefox?

I need to print (to PDF) a large number (about 80) of tabs all at once, but in a specific order. The problem is that the tabs all got opened in the reverse order of what I want. Dragging them around ...
0
votes
0answers
40 views

I'm trying to list size of folders plus selected files on a portable disk

For the purpose of finding the location of my data among many portable disks, I'm trying to create plaintext lists of the contents of all folders and files of certain extensions and sort them by size. ...
1
vote
2answers
475 views

Excel compare cells in columns A and B, show in column C cells only unique to column A

I know there's a formula for this in Excel but I can't get it right. I've got a list of 7000+ names in column A, and a list of 4000+ names in column B. Some are duplicates, appearing on both column A ...
0
votes
0answers
34 views

How to sort bookmarks in Scribus by page?

By default bookmarks in a Scribus document are sorted in the order they are created by the user and must be manually sorted. How can I sort the bookmarks defined in a Scribus document by page number? ...
1
vote
1answer
111 views

Can I change where win7 shortcuts sort in relation to folders?

If i have a group of folders, and somehow i need a shortcut to a folder to be "in the middle" sequentially, how do i fix that? Changing sort by type does not help, sorting by name does not seem to ...
0
votes
1answer
31 views

How to Sort in Unix using a specific location

Hi I have a large text file that I want to sort using a specific location (e.g. 6-12 characters) Ex. Input: 12345222 ABC DEG123456 AAA BBB 12345111VABCGDEG123456 AAA BBB ...
0
votes
0answers
21 views

Adding custome metadata to PDF using Acrobat X

I have some PDF tax files that I would like to separate by year. However, the year created / modified isn't necessarily the year I want to categorize it under. How can I add a "year" field to the ...
0
votes
1answer
209 views

Use the ascii code of a character as an input to sort

I'd like to sort a file with a specific delimiter (ascii 0xff) and the records are zero-terminated. I cannot use the following command though: $ sort -z -t \xff -o data data The error message is: ...
2
votes
2answers
3k views

batch - File last modification time with seconds

I want to know when a file has been modified for the last time. I can get these infos using the following batch script: FOR %%i IN (myfile) DO SET modif_time=%%~ti The problem is that I need ...
0
votes
2answers
92 views

How to customize folder grouping in Windows 7?

I wonder, how to customize folder grouping in Win7? You can group them by Name, Date, etc — but how to create custom groups? Like, I have 30 folders on a disk, and i want them to be grouped under ...
0
votes
0answers
218 views

Excel 2013 - Is there a macro to sort and split the contents of a spreadsheet

I know there any many similar questions to this, but none seem to match exactly... I have a basic Stock List, and want to help to speed up stocktaking, so am looking to create a macro to do the below: ...
-1
votes
1answer
57 views

Issue with Outlook 2013 rule condition “From Specific Address List” [closed]

I am an exchange administrator and I have a user who wants to filter mail based on the first letter of the sender's last name. The only way that I have found to do that is creating a server side ...
1
vote
1answer
506 views

Windows Explrer Sorting order for special characters?

What is the sorting order used in Windows Explorer? I was specifically wondering what special characters sort after the alphabets? As far as I can tell (test), all special characters seem to be ...
0
votes
0answers
236 views

Using VBA to sort cells to match the values in an adjacent column

What I would like to do is write a macro that sorts the values in the range B3:D9 on the left side of the linked image to produce the intended result (shown on the right side). For every value in ...
0
votes
1answer
200 views

Unable to sort selected cells within the Table in Excel 2013

I created a Table in Excel 2013 but I want to sort only selected cells. The table range is A1:I200 but I only want to sort A150:I200. I tried selecting the cells, right click, sort, it sorted the ...
0
votes
1answer
123 views

SortTV perl script error

I'm trying to use a perl script named SortTV (http://sourceforge.net/projects/sorttv/) Every dependencies is installed but I got an error & can't understood it... It's not a specific problem of ...
0
votes
1answer
217 views

Grouping and sorting rows in Excel based on single column

I have a list of families I need to sort by last name in column A. You can see that each child in the family has its own row. The problem is that when you apply sort by column A descending, it does ...
1
vote
1answer
162 views

How do I quickly parse large ASCII files for matching records?

I have lots of files containing data records, stored as space-delimited ASCII files. Each record is a row containing numeric data, with some columns integer and others floating-point eg. 1 1 5711 4 ...
2
votes
1answer
117 views

How to disable message sorting on Thunderbird?

I keep constantly clicking the "subject" sorting button, when I want to click on the newest message. How can I disable the sorting completely? Perhaps by hacking the .exe file? It's pretty much ...
-4
votes
1answer
616 views

how do you ignore empty cells?

I'm using this function to rank data: =SUMPRODUCT(($B$2:$B$11>B2) / COUNTIF($B$2:$B$11,$B$2:$B$11&"")) + 1 This version assigns 1 to the highest value and sequentially increasing ranks to ...
0
votes
1answer
47 views

Windows 8 sorting by name

I have a lot of documents and when I sorting them by Name, it looks like this: Story - descriptions.docx Story.docx Tale - descriptions.docx Tale - maps.jpg Tale v2.docx Tale.docx Why it is sorted ...
1
vote
1answer
293 views

On the command line, what is a “general” and “string” numeric value when sorting?

According to "man sort" there are two ways to sort numerically: -g, --general-numeric-sort compare according to general numerical value and -n, --numeric-sort compare ...
0
votes
1answer
51 views

Sorting iTunes Artist field

I'm trying to sort out my music and I have a couple of artists who have changed their name or have an album with solo tracks and some in a group. Two examples are 'the game' and 'adam and the ants' ...
0
votes
1answer
3k views

How to sort only part of multiple columns in Excel

I want to highlight, for example, rows 5-15 across columns C, D, and E, and sort only that block in ascending order by one of the columns. The trick is that I want all included columns to follow suit ...
1
vote
0answers
238 views

Music Library Sorting Issue

I'm using WMP for for managing my music library. Lately I noticed something. I was reorganizing my library and came across a strange -I mean annoying- behavior of WMP. The way WMP sorts Artists. ...
4
votes
2answers
249 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
123 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
70 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 ...
2
votes
2answers
328 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
190 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
156 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
39 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
63 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
261 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 ...
0
votes
1answer
169 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
831 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
374 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
411 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
150 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
2answers
3k 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
314 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
59 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
5k 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
6k 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 ...
2
votes
1answer
279 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
88 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
997 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 ...