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

learn more… | top users | synonyms (1)

0
votes
1answer
56 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
31 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
11 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?
1
vote
0answers
55 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
44 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
57 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
9 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
45 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
29 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
154 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
74 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
268 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
495 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
88 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
27 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
63 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
151 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
523 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
60 views

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

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
3k 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
32 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
45 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
1k 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
92 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 ...
1
vote
1answer
47 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
47 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
166 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
28 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,, ...
4
votes
1answer
976 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
429 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
170 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
331 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
185 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
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
66 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
43 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
59 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
643 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
110 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
21 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
36 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 ...
51
votes
1answer
42k 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 ...
0
votes
4answers
7k views

How can I sort my data while keeping paired rows together?

How can I pair two rows on a spreadsheet, so that for each data entry I can sort the matrix but the pair of rows moves as a single list of data, retaining the structure of the two rows? For example: ...
0
votes
1answer
45 views

Can I remove the original file while running “sort”?

I'm sorting a huge file, around 400 gigabytes. I'm running out of the disk space and I must do something quickly. Let's assume the original file is called original_file. So I execute (simplified) it ...
1
vote
1answer
2k views

Sorting Dates in Excel By Month

My boss has given me a job in which he has given me the names of customers and their wives who has bought our products from 2 to 3 regional offices. My boss wants me to format all this data into one ...
0
votes
1answer
32 views

Sorting and showing the most repeated row (value)

I have a sheet containing over 200k+ rows with values like this, 10.10.10.10 11.11.11.11 12.12.12.12 10.10.10.10 10.10.10.10 I want to be able to show the most repeated row at the top or extract it ...
0
votes
1answer
131 views

getting todo.sh to sort due items first, then by priority

How can I get todo.sh to put items that are due: today first, then after that sort the normal way (A-Z priority then everything else)? There's this solution, but then you lose A-Z priority and have ...
5
votes
0answers
1k views

Excel 2013, can data be re-sorted automatically?

Is there a way to re-sort automatically? I have automatically updating cells and depending on incoming values the rankings change. I am looking for a way to have the table resort automatically ...
1
vote
0answers
99 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 ...
3
votes
3answers
267 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 ...