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
112 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
382 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
728 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
1k 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 =...
1
vote
2answers
116 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
47 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
239 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
135 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
35 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
390 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
2k 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
141 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
296 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
61 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 “alphabetical”...
0
votes
1answer
49 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
1k 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
63 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
24 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
91 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
55 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 a_02....
2
votes
1answer
894 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 ...
4
votes
1answer
396 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
34 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
105 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
2answers
1k 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
458 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
1answer
133 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
64 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
12 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?
2
votes
0answers
114 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
86 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
64 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
2answers
56 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
32 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
261 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
149 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
851 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
2k 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
255 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 31-...
0
votes
1answer
47 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
1answer
257 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
1k 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
69 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 ...
5
votes
2answers
7k 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
37 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
92 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
2k 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
143 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
50 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
57 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.