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

learn more… | top users | synonyms (1)

-2
votes
1answer
34 views

Join some files in bash

I have a task. I have to join files A:B.dsv, B:D.dsv and N:A.dsv. Column are separated by ':'. And I have to join by relation N:D. And sort end file by D. A:B.dsv: R0X 7M3:48B56 L6R 5X3:08P68 E1W ...
0
votes
1answer
14 views

join - file is on sorted

I tried join two files, but I don't know why join doesn't listen to me. File i: 1 afjsadfjasdf 3 afdadsfa 4 afjdsakjfads 5 asdfadsfads 9 asfadsfads File k: 1 fdasdfadsfads 2 dfasjfadsjfas 3 ...
3
votes
1answer
25 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 ...
0
votes
1answer
32 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 ...
0
votes
0answers
9 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 ...
1
vote
1answer
30 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 ...
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
0answers
47 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
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 ...
0
votes
1answer
17 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 ...
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
11 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 ...
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 ...
1
vote
1answer
68 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
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
66 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 ...
2
votes
1answer
33 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
34 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
48 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 ...
2
votes
2answers
82 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
184 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
125 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 ...
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? ...
1
vote
2answers
52 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
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 ...
1
vote
2answers
101 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 ...
1
vote
1answer
67 views

Lining up sets of data in Excel (both with unique keys)

A related question asks how to line up two sets of data in Excel. I am struggling to figure out how to do this when you have values in both lists which don't exist in the other list. Ie: how would ...
0
votes
1answer
22 views

Sorting files in a folder by the application that created them

I'd like to have a better idea of why there are certain files in my TEMP folder, so I'm wondering if there's any record kept in Windows 7 about the application that created a particular file. I ...
6
votes
3answers
229 views

How to Sort Animated GIFs from Non Animated GIFs?

I have a folder with lots of images and i want to sort animated GIFs from non animated GIFs and move the animated GIFs to a new folder. Tried with software like XnView and XnViewMp for Windows but ...
1
vote
1answer
380 views

Alternate Row Colors of Duplicate Data in Excel

I am working with a dataset in Excel that contains duplicate values and non-duplicate values that are numbers. I would like each duplicate value group to have alternating shades via Conditional ...
1
vote
1answer
101 views

Sort array in the sourcefile

I have written a script using Notepad++, and in it I have hardcoded an array. This is a script which I have expanded on over the years, and thus the array have gotten "unsorted". Let's say that it now ...
0
votes
1answer
99 views

How to sort sheet by groups of three rows without changing internal arrangement of groups

I created an Excel file showing a list of golfers and their scores on 18 holes. I want to sort by the Net Total, while preserving the rest of the formatting. When I try to sort the usual way, I ...
1
vote
1answer
29 views

Are different non-alphanumeric symbols—when used at the beginning of a filename—treated differently when sorting alphabetically?

I’ve long used the trick of adding a dot to the beginning of a folder name so that it always appears at the top of a list of folders when they are sorted alphabetically. But is there an ...
0
votes
2answers
56 views

Select a number of rows from a set in Excel

I have a list of users in locations within my company. Vastly reduced from the 130,000 or so in reality, the data looks like the example at the end. What I need to do is to select a number of users ...
0
votes
1answer
31 views

Linux sort Command: how to sort on a number embedded in a field?

I'm on RHEL 6 using BASH. I'm trying to sort some lines in a file, by a number that is embedded in a field. The name of the file is word.txt. This is the command I am using: sort -n -k4 word.txt ...
3
votes
3answers
213 views

How to correctly sort calendar months “mmm” with AutoFilter?

I need to use filter to sort calendar months in mmm format. Data > Sort > Custom will do it but I cannot make filter work. Months are in a column eg SEP, APR, JAN, APR, etc. Filter just does ...
0
votes
2answers
38 views

Sort on ID, then sort on date, then remove lines which have the older date?

I have a couple of tab delimited files. Each file is structured like so: ID Title Rating Date_Rated What I want to do is merge all these files into one, ...
1
vote
1answer
22 views

How to make sort consider blanks (GNU coreutils)

How can I make sort consider blanks? Original file: n c n b n a What I get with sort file is this: n a n b n c So how can I come to this order: n b n c n a Version: sort (GNU ...
0
votes
0answers
67 views

Sorting HTML content based on second line of table cell

I have an Windows text file, containing the text of an HTML table (no header, no footer) with each cell of the table not in alpha order. I'd like to alphabetize the tables, a la: REDACTED-TITLE-1 ...
-1
votes
1answer
41 views

How to rename single-digit numbers to sort incrementally?

What is the simplest way to add 0's to all single-digit filenames to make them sort correctly? I'd like to stick to the command line if possible. From: a_1.png a_2.png a_10.png To: a_01.png ...
2
votes
1answer
247 views

Is it possible to sort a table by entry modification date? Specifically, how to access from VBA the last modification time of an object?

I have a MS Word document where I accumulate and frequently modify certain data in a very long table. So I would like to sort the data by latest modification time in the rows. Of course if I add a ...
1
vote
1answer
126 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 ...
0
votes
1answer
27 views

Sorting in Microsoft Excel

When I use the Sort "oldest to newest" in the Filter dropdown and I am sitting on, for example Row 400. After I do the sort my screen resets so I am sitting at the top of the spreadsheet instead of ...
0
votes
1answer
65 views

“ls -la | sort +0nr -2 +2d” , what does sort do here?

I hae seen this somewhere written: ls -la | sort +0nr -2 +2d What is sort doing here? What are these arguments.
2
votes
1answer
394 views

How to sort by senders' email address and not by display name in Outlook?

Is there a way in Outlook 2013 to view multiple incoming email addresses as the same contact? For example: Email #1 - Johnny Appleseed japple@yahoo.com Email #2 - JAppleseed japple@yahoo.com In the ...
2
votes
1answer
120 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 ...
0
votes
0answers
18 views

Sort mp3 files based on both name and album in windows explorer [duplicate]

Let's say I have a bunch of mp3 file, is it possible to sort them based on both name and album? in a way that I first see the file listing based on artist name and than within that it will be sorted ...