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
3 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
20 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 ...
0
votes
2answers
38 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 ...
1
vote
2answers
25 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.
1
vote
1answer
31 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
1answer
14 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,, ...
-1
votes
1answer
677 views

(Some Program that lets me) Manually Sort Folders in Windows 7

I want to have some convenient way of remembering the order I put certain folders in, without being forced to rename them. Some of these folders may get deleted and new folders also get added, so ...
0
votes
1answer
697 views

UNIX command to sort the file by the following words, from major sort key to minor sort key: word 3, word 1, word 4

Need help with the UNIX command below to sort the file by the following words, from major sort key to minor sort key: word 3, word 1, word 4. (words are separated by white spaces) sort -t -k3 -k1 ...
3
votes
1answer
2k 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 ...
34
votes
9answers
22k 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.
4
votes
2answers
212 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 ...
10
votes
2answers
6k views

Windows 7, any way to sort folders and files all mixed together?

Is there a way to sort folders and files by their name all mixed together in Windows 7? It would be easier to understand if you look at this page. I want my folders and files arranged like the ...
0
votes
2answers
74 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 ...
1
vote
1answer
34 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
3answers
50 views

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

Total n00b here. 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 ...
1
vote
1answer
984 views

Sorting by Date Modified in Windows 8

In prior versions of Windows I used to be able to sort my folders by date modified. If any files in those folders where added, removed, changed etc... the folder date would be updated. However, in ...
0
votes
5answers
11k 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 ...
3
votes
3answers
94 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
2answers
46 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 ...
4
votes
3answers
18k views

Fixing the first row as sortable title in Excel 2007

I know this is super easy, I just couldn't find it. I'd like the first row in an excel document to be the "title" field. I want that: Whenever I scroll down, this row will remain fixed I can sort ...
0
votes
0answers
29 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 ...
39
votes
12answers
47k 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): ...
1
vote
2answers
97 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
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
20 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?
1
vote
4answers
10k views

How to filter an Excel column for entries matching a master list

The general question entails sorting a large Excel 2007 list to find entries that match smaller subset list. I have a couple of ideas on how to approach the problem, but I lack the technical ...
0
votes
2answers
49 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 ...
0
votes
0answers
37 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
37 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 ...
1
vote
0answers
36 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
55 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
23 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 ...
0
votes
1answer
14 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
0answers
43 views

What is the best order of item fields in for different group with various template zabbix?

In my company, we have about 30 servers which i monitor them by zabbix. Some of them are Windows base OS and some others are Linux (CentOS, Debian, Ubuntu) OS base. Basically i create a Template, ...
0
votes
3answers
224 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
35 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 ...
0
votes
2answers
3k 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
1answer
69 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 ...
3
votes
2answers
2k views

Sort order in Windows Explorer

The behaviour described below occurs on Windows-7 systems and on Windows XP. We operate in a dual-language environment - English and Hebrew. When in Windows Explorer we sort files by name, the order ...
0
votes
1answer
23 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 ...
10
votes
1answer
15k views

How to sort an Excel spreadsheet columns by row contents?

How do I sort the columns of an Excel spreadsheet? The Sort command from the Data menu only allows me to sort rows by the value of a column. I want to sort the columns alphabetically by the contents ...
0
votes
1answer
24 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 ...
11
votes
1answer
4k 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 ...
1
vote
1answer
238 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
0answers
32 views

LibreOffice Calc dynamic text sort

Given the following table: A B 1 AA AA 2 HH BB 3 BB HH 4 II II 5 UU LL 6 LL UU I need to sort the values of column A to B dynamically, using only ...
2
votes
0answers
166 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 ...
5
votes
2answers
720 views

ls version number sorting Mac OS X

Is there an equivalent to ls -v in Mac OS X that will do version number sorting? In Mac OS X, ls -v does NOT do version number sorting, but the Finder seems to.
0
votes
0answers
33 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 ...
1
vote
2answers
329 views

Excel: Remove lines with duplicates in column B, based on data in Column A

I need to find duplicates in Column B; and then delete the entire line if the the value in Column A is the number 4. There are lines that need to be kept and have "4" in Column A. A B 1, John 4, ...
0
votes
3answers
49 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 ...