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

learn more… | top users | synonyms (1)

0
votes
0answers
5 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
17 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
32 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
39 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 ...
1
vote
0answers
40 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 ...
0
votes
1answer
12 views

How to force sorting of my tag list?

My list of nested Evernote tags, after some careless tag creation and renaming, is no longer in alphabetical order. I know that if I remove each tag from its parent tag, and the re-add, it will be ...
0
votes
2answers
18 views

GNU sort file names with prefix and one or two digit

I would like to use GNU sort to have the file names from a find command sorted by the numbers in the name. The name of the file is "cycle" then the first number to sort by, then ".subset", then the ...
0
votes
1answer
7 views

Linux redirect output ro earlier agument

Is there a way to redirect output on Linux to a former argument. For example, sort file.txt > file.txt Would there be a way to avoid typing file.txt again?
0
votes
0answers
12 views

Sort mails by 3 criteria on Thunderbird

I would like to sort my mails by 3 criteria, on this order : Date (new mails up the list) Read state (unread messages upper) "Starred" (starred messages at the uppest) But it seems that it is ...
0
votes
0answers
17 views

Spreadsheet Function Help - From A Table Of Names And Birth Dates Pull A List Of Names As Of A Reference Date And There About

I have posted this question before, and got half-solution. Pls have a look at this link to get an idea. http://yogi--anand-consulting.blogspot.in/2014/11/yogifrom-table-of-names-and-birth-dates.html ...
2
votes
2answers
51 views

Sort structures in file [duplicate]

For example I have file consisting of structures like name = { foo = bar; ... }; So in file there are lots of structures like this. How can I sort them (I'm using vim but emacs is surely ok ...
0
votes
0answers
29 views

Custom sort selection

I would like to be able to sort a selection based on the order of another range somewhere in the same workbook. While I realize I could add custom list and then sort the selection based on this, this ...
0
votes
0answers
8 views

Order by sub-type in Windows File explorer

Say I have the files: File1.bla.txt File1.htm File1.foo.txt File2.bla.txt I want to order them first by type (txt/htm) and then by file sub-type (if it has any: bla/foo). So: File1.htm ...
0
votes
2answers
35 views

Dates in Excel - sorting

Is it possible to sort a list of dates by week? For example, if I have a list of specific dates and I want to group them into week 1, week 2, week 50 of the year, is it possible?
0
votes
2answers
26 views

Sorting in Excel

I have entries in Excel that are like this: 52173 PURCHASE USA*SNACK SODA 52172 PURCHASE USA*SNACK SODA 668414 PURCHASE REDBOX *DVDRESERVATION I would like to sort the rows ignoring everything ...
1
vote
1answer
64 views

How to use linux bash “sort” command in a portable script?

I am writing a bash script and I want to make it portable, to have the same results in the other computers. From this question I learned the system settings, like language settings and possibly other ...
0
votes
1answer
33 views

Unexpected result from sort command of linux bash

I have a file foo.txt with this content: chr1 15 chr11 5 chr11 8 chr1 7 chr2 23 chr1 35 I tried to sort it first according to the first column, and then according to the second ...
2
votes
1answer
52 views

Can I sort in excel but read the cell values from right to left?

I have an excel worksheet list of names and email addresses. Some of the email addresses, however, are cutoff on the right and have "...". For example: some email addresses are "test@test_user...". ...
0
votes
2answers
48 views

Sort Excel Row Based on Values in Another Row

Sorry if this question has already been answered, I looked but I didn tfind anything that was quite what I am trying to do. I have a lot of spreadsheets where I have something like: A|B|C|D|E|F... ...
0
votes
2answers
30 views

Sort files in Windows by name - according to date

I have a bunch of PDF invoices in a folder. They are named according to their dates. For example: 28-02-13.pdf 28-02-14.pdf 28-03-13.pdf 28-06-13.pdf 29-11-13.pdf 30-04-13.pdf 30-04-14.pdf ...
0
votes
1answer
18 views

Excel 2007. Data Tab is grayed out. Nothing on that Tab is available

I'm trying to sort a file to which I add rows daily. I usually have no trouble sorting, but from some reason all the items on the Data Tab are 'grayed out' and unavailable. Any idea what's caused ...
0
votes
0answers
19 views

How to custom sort Window Explorer on 'Comments' column

I've added Comments to .pdf files using the program File Metadata, and then I enabled a Windows Explorer comments column. This sorts reverse alphabetically i.e. Zaphod, Widget, Constantine, Adam, ...
0
votes
1answer
66 views

Sort numbers in left to right in ascending order

How to arrange in ascending order from left to right in vi or with the sort command? Sample before arrangement: 2 3 3 6 5 1 4 2 5 8 I want it in this way: 2 3 3 6 1 5 2 4 5 8
0
votes
1answer
140 views

Sort & Ranking Functions in Excel for Time AND Number Values in one Column

I have a spreadsheet that is being used to track and score a fitness competition, each workout has a time cap, so athletes that complete the workout under the time cut off are given a time as their ...
1
vote
0answers
46 views

Separation of work, personal, and private , for all things tech?

Increasingly I'm finding it's very difficult to separate anything on my computers and devices. Everything syncs everywhere, I need to do work from my home computer, I need to do personal things from ...
3
votes
2answers
716 views

Alphanumeric sorting in Excel

In Excel, is it possible to sort alphanumerics from a-1, a-2, a-3...a-123 instead of a-1, a-10, a-100, a-11? Sorting via oldest to newest or via A-Z, definitely won't give me the result I want. I've ...
0
votes
1answer
29 views

how does sort compare lines?

I've always assumed that sort without any additional arguments, will sort a file in lexical order. However today I ran across following test case: sort test2.txt a/a a/c a//c a/d As you can see the ...
1
vote
1answer
27 views

Using Outlook 2010 Custom Views

I frequently switch between emails sorted by date (newest on top), sorted by From, and sorted by conversation (oldest on top). I'm tired of right clicking and sorting my emails, especially with ...
0
votes
0answers
241 views

Why am I unable to sort data in Excel?

Here is what my spreadsheet looks like: I am trying to sort these invoices first by type (Column B) then date, and finally by amount (which shouldn't apply, but why not). I have checked for ...
0
votes
0answers
53 views

why is my sort slower with more ram?

System specs below. I recently purchased 2X4 RAM: Corsair XMS3 8 GB (2 x 4GB) 1333 MHz PC3-10666 240-Pin DDR3 Memory Kit CMX8GX3M2A1333C9 I already had 2X2 in there for a total of 12GB: Corsair ...
0
votes
0answers
27 views

Ignore certain characters while sorting data in libre/office calc

I have a list of transliterated chinese terms in a table showing Wade-Giles (W.-G), chinese characters and Pinyin transcription. Example, (sorted W.-G column only): P'u Te Ssu P’u t’uo-shan Pai ...
1
vote
1answer
36 views

spreadsheet: sorting by the first n characters of the entries of a column then by another column

Is there any way to sort an OpenOffice Calc spreadsheet by the first n characters of a given column then by another criterion? For example suppose that we have the following 4*2 spreadsheet (Note ...
1
vote
2answers
37 views

Trying to cat the result of piped commands

I have a folder of files that are named list20140801.txt list20140802.txt .... I'm trying to do this ls | sort | tail -3 | cat But it is just giving me the file names, not cat'ing them.
0
votes
2answers
98 views

How to sort columns in Excel so that only one value appears in each row?

Say I have a a spreadsheet with the following data: A B C D --------------------- 2 1 0 2 3 2 1 4 5 3 3 6 7 5 6 8 11 8 10 10 ...
0
votes
1answer
20 views

Sort piped to uniq unexpected output

I have a file that looks like this: "string",192.168.1.0,,TX,192.168.1.2,,,100,0,0,10,10,10,, "string",192.168.1.0,,TX,192.168.1.1,,,100,0,0,10,10,10,, ...
2
votes
1answer
309 views

Case insensitive sorting

Vim's default sort is case sensitive, and produces results like this: A B a How can it be made case-insensitive, to produce the following result given the same input? A a B
0
votes
3answers
214 views

Excel filter duplicate values in column A and filter out rows which have column C blank

How to filter duplicate values in column A and filter out rows which have column C blank. I have 2200 rows in Col A (the first 1400 rows also have data in Col B & C, the next 800 rows are ...
3
votes
1answer
101 views

“Sort Lines” disabled in Sublime Text

I'm wondering why I can't click on Edit > Sort Lines in my Sublime Text 3 ? I often use it and I don't think I've done anything which could disable it, so I don't know where to search... What ...
0
votes
2answers
128 views

is there a way to sort files in a directory by view count? Win 7

As per the title, can files in a directory be sorted by view count in windows7 ? I have a folder with a lot of videos. I want to delete bottom 20 least viewed videos. This would require me to sort ...
0
votes
0answers
89 views

How can a Macro sort dates from oldest to newest?

I'm doing account statements in a bank and I need to be able to make them fast, so I am using macros for making this process. However, there is a step that I always have to do that a macro won't let ...
0
votes
0answers
91 views

Changing the order Of Dropbox photos

The order of the photos we have in dropbox is alphabetical according to caption rather than in the order in which they were taken. How do I change the order?
0
votes
1answer
30 views

How to calculate occurrences of some word in table

How can I calculate how many times occurrences any of these "value" Column for example I need: N 97 5 N 72 7 N 83 22 N 70 3 N 76 8 Z 34 7 N 85 2 ... ... ... and sorted ...
0
votes
0answers
52 views

If sort created temporary files, does it mean it's out of RAM memory?

I was sorting a large file (101MB - about 700MB after unzipping) using sort command on server that has 48GB of memory. It was the only heavy job it was doing at that time. However I noticed that sort ...
0
votes
1answer
42 views

What's the strategy used by sort when field not found?

I got a file named test, its content is like 111 222 11 22 111 223 12 22 33 11 2 25 222 331 11 2 33 2 1 33 33 22 33 I used: sort -bk2.3 test But the result confused me, those lines which doesn't ...
0
votes
2answers
53 views

Why “ sort file > file ” would remove all the content of that file?

Today I'm learning sort command. I find that, I can use sort file1 > file2 To inject the sorted file into file2 But when I use sort file1 > file1 file1 become empty! Why?! I know I ...
1
vote
0answers
218 views

save folder sort setting in windows 7

I have Image folder and sort my image by date. Everytime I open a folder, windows sorts all file by name and then green bar fill address bar. after that all image sort by date. ...
0
votes
1answer
87 views

Linux: Sort /etc/fstab by the mountpoint field

On linux, how would you sort the /etc/fstab file by mountpoint? I'm interested in sorting a section of fstab (whatever is mounted under /x) in such a way that parents are mounted before its children ...
0
votes
1answer
19 views

Inverting Music Folder Sorting

Due to various circumstances I have a large collection of .MP3 files in folders by artist, then album. This of course leads to issues with albums with more than one artist on them which end up spread ...
0
votes
1answer
25 views

Excel 07 - declaring and sorting chunks of arbitrary size

Let's say I have a list of Abbreviations: As you can see, the only layout "rule" is a blank line between entries. I should now like to sort them by their abbreviation: Using Excel07 and having ...