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

learn more… | top users | synonyms (1)

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
150 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
68 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
221 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
358 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
73 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
22 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
57 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
126 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
465 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
58 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
39 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
900 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
90 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
41 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
45 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
45 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
155 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
26 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
855 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
402 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
160 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
292 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
164 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
62 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
57 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
537 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
107 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
34 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 ...
46
votes
1answer
37k 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
3answers
6k 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
43 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
30 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
125 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
93 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
257 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
3answers
59 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 ...
2
votes
1answer
3k views

Is there a way around broken pipe?

I have a directory with a large number of files. ./I_am_a_dir_with_many_subdirs/ Within a script I'd like to find all subdirs in it, to sort them and to output to a bash array. So, I do: ...
0
votes
1answer
166 views

how to reverse the sort order of tabs in firefox?

I need to print (to PDF) a large number (about 80) of tabs all at once, but in a specific order. The problem is that the tabs all got opened in the reverse order of what I want. Dragging them around ...
1
vote
2answers
1k 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 ...
1
vote
2answers
328 views

Can I change where win7 shortcuts sort in relation to folders?

If i have a group of folders, and somehow i need a shortcut to a folder to be "in the middle" sequentially, how do i fix that? Changing sort by type does not help, sorting by name does not seem to ...
0
votes
1answer
37 views

How to Sort in Unix using a specific location

Hi I have a large text file that I want to sort using a specific location (e.g. 6-12 characters) Ex. Input: 12345222 ABC DEG123456 AAA BBB 12345111VABCGDEG123456 AAA BBB ...
0
votes
1answer
284 views

Use the ascii code of a character as an input to sort

I'd like to sort a file with a specific delimiter (ascii 0xff) and the records are zero-terminated. I cannot use the following command though: $ sort -z -t \xff -o data data The error message is: ...