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

learn more… | top users | synonyms (1)

3
votes
1answer
22 views

Varying Format Part Number Sort Issue

(Current Sort Sample:) 2-1203-4 2-1206-3 2CM- 3-1610-1 3-999 … AR3021-A-7802 AR3021-A-7802-1 B43570- B43570-3 I am working on an 8000+ record parts list. The challenge I am running into is that ...
16
votes
3answers
6k 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 ...
0
votes
1answer
29 views

Sort file by two column in the event of two the same value

I want to sort files by one column, but in the event of two the same value I want to sort these two by other column. How can I do it? My file: 1 2 3 1 3 2 1 4 3 2 4 1 2 1 3 3 1 ...
1
vote
0answers
43 views

Bash sort and join problems

I have to join two files. Firstly, I use commant sort and made two new sorted files. Next I use join, but it doesn't work. My script: sort -t ',' -r -k 4,4 file1.csv > sortf1.csv sort -t ',' -r ...
1
vote
1answer
28 views

Windows Explorer - Treating cameras/Android file systems like disks and sort by date

My Android current, and previous, Samsung phones identify as a camera (technically a media device) to Windows. They do this because they have internal flash and to mount the file system to another ...
-1
votes
0answers
19 views

How to sort Clients by money spent on paypal [closed]

So I have an app that receives small payments and I have several returning clients. I'd like to sort all my clients by spent money so I could target those that are spending the most. Is there any way ...
6
votes
2answers
822 views

Mail.app - What sets sort order when adding To addresses by typing Group name?

Using Mail.app in Mac OS X (10.6.3) I'm seeing apparently random sort order when sending a email to a group. Not a major issue but you'd think it be alphabetical?!? To reproduce: Compose New ...
0
votes
0answers
8 views

Windows Live Mail 2011 - Sort Sent Folder By “To” then “Sent”

My boss uses Windows Live Mail 2011 on his work PC for his non-work accounts. When he looks in his Sent Folder and sorts by "To" the emails appear to then sort by subject by default. This isn't ...
0
votes
1answer
16 views

Sorting in SSRS 2008

I am trying to sort a column from largest value to smallest in SSRS 2008. These values are derived from an expression, not an actual data field. So I am wondering if there is a way to sort this ...
2
votes
3answers
36k 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 ...
3
votes
1answer
36 views

Is it possible to change the 'Type' of a directory in Windows

Directories in Windows are always tagged as "File folder" in the explorer: Is it possible to edit this field? To introduce a new kind of folder? I would like to do that in order to enable another ...
1
vote
2answers
32 views

Ordering of filenames in linux - not purely lexicographical?

Given a few files in a directory data the following ls command provides a surprising result in the sense of how they are ordered: for f in data/*; do echo $f; done ...
2
votes
2answers
9k 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
1answer
118 views

Change the sort order in Thunderbird on multiple columns

I would like to be able to sort (order by) email messages based on three (3) of the columns. Specifically at the top would be Starred, then Unread and then by Age (Newest at the top) (with Starred ...
6
votes
1answer
3k views

Sorting by Date - Very Slow

I'm using Windows 8 RTM. I have about 1,100 files in a folder. When I sort by date (in either direction), The address bar shows the green progress indicator as if it's working hard to perform the ...
0
votes
1answer
3k 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 ...
1
vote
0answers
98 views

How to move starred and unread messages to top without destroying the order by date (descending)?

I'm trying to order my messages in my thunderbird inboxes and have multiple issues. I want to oder my mails like the following: Importent (starred) messages should always stay on top. Unread ...
0
votes
0answers
9 views

Sorting Messages by date

I want to sort my messages from email which gets the application Phoneleash but I don't have idea how to do this. This is example massages: ➥telephone_number Message content--- [Sent: 16:43 ...
0
votes
0answers
9 views

adjust target cell in formula — target cell will change location when rows are sorted

I have a sum in cell B10. in C1 I want to show the value of B10, but rows 5-10 change each time the worksheet is used as a result of sorting. Is there any way to link the formula in C1 to a specific ...
1
vote
2answers
35 views

Sorting rows in Excel 2013 based on when they were added [closed]

Is there a way to sort rows in Excel 2013 based on when the rows were added?
0
votes
0answers
9 views

Pivot Table loses Custom Sort Order when saved

I have a Pivot Table in Excel 2010 on which I have sorted one column with a Custom List: Jan-2008 Feb-2008 [..] Nov-2025 Dec-2025 This works fine until I save the workbook. When I re-open the ...
1
vote
1answer
66 views

Sorting by different currency symbols in Excel 2010

The Accounting Department enters receipts of money in different currencies ($, shekels, & Australian pounds). Is it possible to sort a column containing mixed currencies by currency type if the ...
0
votes
0answers
32 views

Fix inconsistent windows sorting (by name)

Here are some files that are sorted by name. The OS understands correctly that 2 should come before 10, great. But notice that The "new text document" come last, after "new text document2" even ...
3
votes
1answer
47 views

How to sort the output of find? [duplicate]

I'm using the find command to list files with their name containing a string: find ~/ -type f -name "*inductive*" I would like to use a pipe to sort the resulting list of files. I would like to be ...
56
votes
12answers
74k 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): ...
0
votes
2answers
46 views

Automatically “reject” images submitted to a folder that don't meet certain resolution/size criteria?

I receive a large number of images that are submitted by various people within our company. Rather than go through all of them manually, is there a way to have images that aren't at least 300dpi and ...
2
votes
1answer
64 views

Sort --parallel isn't parallelizing

I'm trying to make unique a set of lines pulled from a file with egrep with sort -u, then count them. About 10% of the lines(all 100 characters long from the alphabet [ATCG]) are duplicated. There are ...
49
votes
1answer
41k views

Sorting lines in Notepad++ without TextFx plugin

Current version of Notepad++ is 6.6.3. Version 6.5.2 is the first, that introduced native (without plugin) sorting function to Notepad++. At least that's what they claim. Because, even though we're ...
3
votes
2answers
1k 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
9answers
40k views

My excel spreadsheet won't sort/alphabetize properly

I have a spreadsheet with multiple columns and over 4000 rows. I need to sort, then alphabetize my report and everytime I do, there are 43 rows that do not sort with the rest of the report; they go ...
6
votes
1answer
824 views

Sorting mail in Thunderbird by both unread status and by date

Is there any way to make Thunderbird sort mail so that unread mail is always at the top and the e-mails are sorted by date in descending order persistently? Maybe an add-on that someone can recommend? ...
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 ...
2
votes
1answer
31 views

Save a multi-column custom sort for easy access by other users.

I have a large table in Excel 2013 which I will be distributing to a group of users. Each row in the table has a unique ID, with a combination of alphabetical characters, numbers, and periods. For ...
2
votes
1answer
33 views

Can not change default explorer sorting option

Like the title says: I am not able to change the default sorting option in windows explorer. At the moment folders and files are sorted by date modified, but I'd like to change this to sorted by name. ...
0
votes
2answers
47 views

Excel 2013 Sorting alphanumerics with spaces

I have a list of Hebrew dates that looks like this (actually over 200 entries, of course): Tammuz 5 Nissan 7 Tevet 10 Tevet 10 Tishrei 11 Av 2 Adar 1 Adar I 21 Tammuz 14 Tammuz 25 Tammuz 23 ...
13
votes
3answers
7k 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 ...
2
votes
1answer
2k 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 ...
2
votes
2answers
81 views

Sort by number at the end of the file name in Windows Explorer

I want to know how can I sort my files in Windows Explorer using the last two digits in the file name. I have the following files in my folder: f00001.jpg f00002.jpg f00003.jpg b00001.jpg b00002.jpg ...
0
votes
1answer
170 views

Change the “modified date” of a folders (in possibly powershell)

From time to time, when I force-shutdown a Windows Server 2003 machine (I have no choice), the folders contained in a certain directory all change their 'modified date' to the current date. Luckily, ...
2
votes
1answer
117 views

Excel Spreadsheet Not Sorting

In my excel spreadsheet, I am trying to randomly sort a large list. I am doing this by adding in a new column to my table. This table is assigned a random integer between 1 and 10. This is done by ...
2
votes
1answer
119 views

Is there a Unicode-aware LC_COLLATE sort order which respects punctuation?

As far as I can tell, setting the environment variable LC_COLLATE=en_US.utf8 changes four things compared to LC_COLLATE=c, regarding how programs like ls will sort files: Unicode characters are ...
8
votes
2answers
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 ...
1
vote
1answer
1k views

Sorting two non-adjacent columns without affecting any other column

I have two different columns on Excel. I want to create a script that will sort Column F, (Have a header) and will sort Column B based on where Column F's sort worked out. (Without affecting any ...
1
vote
1answer
266 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 ...
1
vote
2answers
49 views

How to find (or sort into sub-folder) multiple TIFF images with layers and/or transparency?

I have a folder with many TIFF files which I need to convert to JPEG. However some of the files have layers and/or transparency and these I don't want to convert. So how can I move these TIFF files ...
0
votes
0answers
20 views

Can I add a custom sort order to Word 2013?

In previous versions of Word it was possible to add a new sort order...instead of the provided sorts for number, date, etc. you could add days of the week, months, etc. Is that possible in Word 2013? ...
3
votes
2answers
917 views
1
vote
2answers
98 views

Given key-value content, how do I group values by key and sort by value?

I've the following sample input format (file or stdin): key1: 1 key2: 2 key3: 3 key1: 4 key2: 5 key3: 6 Is there any few-liner which can group values based on the key and then sort? Expected ...
0
votes
0answers
22 views

Kingsoft Spreadsheets = “Free” version of Excel…won't Sort by column Headers any more

I've had this happen even in Excel, but it's always annoying. I'll be sorting just fine, no worries, then boom, it will refuse to sort by the column Header and will only look at the first cell of data ...
47
votes
10answers
32k views

Unix: ls, how to sort first directories then files etc

I would like to use ls command to first show direcotries and then files. I tried ls -la | sort -k 1 But I got a wrong order.