The sorting tag has no wiki summary.
1
vote
2answers
23 views
How can I sort a long list of text alphabetically?
How do I sort rows of text alphabetically without using specialized third party software or plugins (like Notepad++/Word/Excel/et al)?
I suppose what I'm perhaps asking is -- How do I sort rows of ...
0
votes
1answer
28 views
How can I permanently divide / separate files, folders, and shortcuts on Windows 7 desktop? [duplicate]
Basically I want to devote a flexible, visibly divided fraction of my screen to each type of icon visible on the Desktop (files, folders, shortcuts).
What will I (or someone much more skilled than I ...
-1
votes
0answers
46 views
How to avoid sorting rows copied from other rows?
I have a payroll that contains 30 names of workers. I sort this payroll in three different ways: 1) ORDER 1; 2) ORDER 2; and 3) GROUP.
I have copied the names into another group of rows, every one ...
2
votes
6answers
3k views
How to sort images into folders, based on resolution?
Background: I've got a folder full of saved desktop pictures. I'd like to put them into folders, based on their resolution - 1024x768, etc. Creating the folders on the fly is a bonus. Currently, the ...
2
votes
3answers
93 views
weird filename sorting (bash, ls, sort)
Good day, everyone.
I'm trying to feed my music to mplayer, like this: mplayer *, but getting wrong track order.
Here's what I get with ls (as well as ls -1, ls -1 | sort), note the order of the ...
0
votes
0answers
15 views
How to sort Google Docs Table sorting recursively? [migrated]
Having a table with data like:
- + + -
- - - -
+ + - -
where + and - are created via '-, '+ commands, How to sort it recursively (probably other word shall be used) meaning sort ...
1
vote
1answer
257 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
1answer
36 views
How to sort an Excel column using the following characters
I have a column with letters W and E following numbers, i.e.
4e
5w
6w
7e
7e
, and I want to sort the column into e and w.
Any help would be appreciated.
3
votes
2answers
442 views
How do I randomly sort groups of multiple lines in a multi-GB file?
I've got a multi-GB file that has elements in 4 lines, and I would like to have every 4 lines randomized in another file, this is, keeping each four lines grouped and randomize those sets. Is there an ...
1
vote
2answers
65 views
How to manually sort files in win explorer?
I want to manually sort (drag and drop) my files in a certain (not in all) folders (win xp sp3).
Is there any fix to do it ?
If no - is there another file explorer with the feature.
5
votes
4answers
208 views
I need an easy way to 'google' through all my PDF files - anything like this exist? [duplicate]
Here is my scenario and system:
System: Win-7, 64-bit.
Scenario: Very simply, I have a folder on my dropbox account, titled \Papers. Within this folder, I have a lot of PDF files, and I have even ...
1
vote
1answer
94 views
Vim - sort blocks of code within blocks
My code (scss):
.cinderblock {
@include minwidth();
background-image:url("images/cinderblock.jpg");
background-position:top center;
background-color:#b79966;
height:528px;
...
20
votes
7answers
22k 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):
...
0
votes
1answer
38 views
Correct sorting after text to columns in EXCEL
I have some data in which one column represents the Days of Operations, as below:
-------
Days
-------
15
7
1234567
etc.
I want to "break" the column (via text to columns option in the Data tab of ...
-1
votes
2answers
105 views
Recomposing data structure
I've a worksheet of 35k rows of the kind in the first table below that I want to reshape as in the lower table.
So, I want to reshape this data in a way to get all the people within a specific ...
1
vote
2answers
9k views
Excel Sort Numeric Column By Number
I have a column of integers in my spreadsheet, and the column is formatted as a number. Each cell inside the column is formatted as a number.
But I can't seem to sort them in numerical order - you ...
0
votes
1answer
71 views
How can I sort a list of numbers, by its last 3 digits in Excel
I have an Excel spreadsheet with a list of numbers in the first column (that is: I have a number in A_1,A_2,...).
Each one of the nubers if have 8-9 digits and I would like to sort this column by its ...
0
votes
0answers
31 views
Presorting Email into separate pst files to keep both sent and received in the same exported pst
A few years back when researching this problem I ran across a program that came close to being a perfect solution. It would not work for what I needed but I showed me some possibilities that I would ...
-4
votes
4answers
86 views
Finding values that only appear once in column
I have 4 columns and ~10K rows. I wonder whether it is possible to extract the rows where the value in column (A in my case) occurs only once.
I don't want to filter out the duplicates, just the ...
0
votes
2answers
120 views
Why do I get an #REF! error after sorting?
In my workbook I use this formula:
=INDEX('G:\Manufacturing\WH\EXPORTS\Scanning_Reports [ScanningReport.xls]Sheet1'!$D$1:$D$65536;AB3)
It works fine but when i try to sort the data i got a #ref! ...
1
vote
1answer
41 views
Make Excel Row Height Stay when Sorted
I have an Excel 2007 spreadsheet and need to make some rows bigger than others so there is vertical space for a signature.
These cells are colored differently, but the height doesn't stick with the ...
2
votes
2answers
144 views
Excel mass add Data to existing sheet
I have an Excel Sheet with keeps track of Persons, who have gone to certain Activities. Now i want to add an Activity with hundreds of Persons, of which some have gone to others already.
Then I want ...
0
votes
1answer
52 views
How to sort folders by last characters of folder name in Windows 7?
I have a stack of client folders with names like this:
eastcoal 008
mee 022
orr 047
owaka 032
owen 025
powernet006
redpath 031
Normally this works, but sometimes I'd like to sort by the number. ...
1
vote
1answer
66 views
Office 2007: How to sort an Excel Table from within a Word macro
I have written a Macro in WinWord2007 which lists styles and their properties in an Excel table. The table is made accessible by the following 3 lines:
Dim Oxl_Sheet As Object
Set Oxl_Sheet = ...
0
votes
1answer
38 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
2answers
203 views
How to reorder folders? (as displayed in `ls -U`)
I've got a number of unordered folders on a memory stick, which my car stereo shows in order of their real position on the stick (i.e. same as ls -U) What's the easiest way of physically reordering ...
3
votes
2answers
656 views
How to physically reorder files `03.mp3 01.mp3 02.mp3` (`ls -f`) in a directory?
The physical order of the files matters when I copy them onto my USB stick and listen in car mp3 player. Most of my music album folders are unsorted, e.g. ls -f may produce:
03.song3.mp3
01.song1.mp3
...
10
votes
6answers
3k views
Sorting human readable file sizes
How can I sort a list using a human-readable file-size sort, numerical sort that takes size identifier (G,M,K) into account? Can I sort "du -sh" output for example?
Problem:
Consider the problem of ...
1
vote
1answer
2k views
Funky mail sorting and grouping in Outlook 2007
In outlook 2007
I group mails in a folder by subject with mails in each subject group sorted by Received date (newest to oldest)
This works fine; I tick 'Subject' and 'Show in groups' in the context ...
2
votes
1answer
64 views
Tagging or defining automatically in an Excel or Libre office spreadsheet?
I want to review and sort my expenditures in a spreadsheet where I have all my transactions listed. Is there a way to automatically label or tag to categorize the transactions like in a budget ...
1
vote
2answers
80 views
How can rearrange my columns to rows in Excel?
It is a bit complicated to describe in words, but I am making a literature review and I need to map how often certain theories are used within certain themes or topics. I currently have a table like ...
3
votes
2answers
182 views
How to sort Windows 7 taskbar thumbnail previews?
Here is a screenshot of the list of windows I have stacked in my Windows 7 taskbar. This is just for Explorer, but similarly I have lots of stacked windows of other processes as well.
Currently ...
4
votes
3answers
1k views
How to sort list-style numbers in Excel?
I have a column of "numbers" in Excel that I would like to sort as follows:
1.1
1.2
1.2.1
1.2.6
1.2.9
1.2.10
1.2.11
1.3
However, regardless if the cell's type is number or text, Excel sorts them as ...
-1
votes
1answer
159 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 ...
2
votes
1answer
101 views
How to setup DLNA sorting
What is the best way using a windows server (as the source) to provide an easy to access listing of available videos for use by DLNA enabled television sets (specifically Samsung)?
I've created ...
0
votes
0answers
184 views
How to view all my Google Chrome bookmarks, sorted by date?
I want to see a flat list of all my bookmarks in Google Chrome, sorted from the oldest one to the newest one.
How can I achieve this ?
0
votes
0answers
169 views
Excel VBA macro to sort sheets in a custom order?
I have a workbook with over 20 sheets. Each sheet contains an error type, and a list of records with that error. These workbooks are produced elsewhere and then sent to me.
I want to sort the sheets ...
7
votes
2answers
5k views
fatsort for Windows 7
I've used a program in Linux called fatsort to reorder the directories on my USB flash drive so that my car stereo navigates folders in alphabetical order instead of random order. Is there any ...
3
votes
2answers
70 views
how can I sort duplicate values in excel without repeated it sequence
i want the excel sort the values A to Z first then take the duplicate values to sort it again below A to Z like the following:
if i have the values a,c,b,e,d,a,c when i sort it a to z it's look like ...
4
votes
2answers
2k views
Sort order “Other Calendars” in Outlook
If I open a Shared Calendar in Outlook, it will be added in the "Other Calendars" section. Unfortunately Outlook doesn't sort them by Name. Is there a way/hack to sort them alphabetically?
1
vote
2answers
62 views
sort numbers in excel10
this is a sample of my movie list as you can see 61 is at the top and 8mm at the bottom
please explain how i can have 1 at the top and 3000 at bottom
61
.45 2006 dvd
10 1979 dvd
10 items or less 2006 ...
1
vote
1answer
225 views
Microsoft Excel 2003 - Merge by Column
I'm trying to merge two excel files, here is the structure of the files:
[A] [B]
I want to add the column B from one file to another as column C, but the thing is that they have some rows under A ...
2
votes
1answer
49 views
How to output a partial or a number from a mataching in grep or ack
I have a text file demo.txt like below.
This is a line with id (9)
This (8) is another line with id
(10) This is a line with id too
11 This line does nothing
The file has some lines with id ...
1
vote
1answer
1k views
How to sort audiobook on iTunes?
I have a question that might seem dumb, but I didn't find anything on Google.
How can I do to sort my audiobook tracks on iTunes?
I have books with 4 or 5 CDs and I'd like them to appear as one.
I ...
0
votes
1answer
84 views
Sort files based on their meta-data
At a local storage (ext3/ext4) I have thousands of files of various types. I need to sort them, however I can come up with the criteria to do so as long as it's possible to get an overview again.
I ...
1
vote
1answer
64 views
Sort columns next to last column in Linux
I have multiple files:
File 1
a 1 2
b 3 2
File 2
a 2 2 3
b 4 3 3
File 3
d 3 1 2 4
e 4 1 1 2
I'd like to sort the files according to the column next to the last column, after sort:
File 1
...
0
votes
2answers
46 views
How to add another sort tab for files in windows?
I am working with a directory of pdf's which have been scanned from actual documents in a file cabnet. When viewing a folder's contents in windows by clicking the tabs above the information users are ...
0
votes
0answers
73 views
Arranging files in a folder Mac?
Im running Mac OS X Lion 10.8.2 and every time I boot up and go to my Applications folder the apps are all over the place, I proceed by arranging them alphabetically but later they are all over the ...
0
votes
1answer
71 views
sort du -sh by size in human readable
with the command
du -sh *
I get the summary of files in MB,GB, etc.
If I use
du -s * | sort -nk1
I get the summary sort by size.
How I can get the summary sort by size in MB, GB, etc?
Edit
the ...
5
votes
1answer
78 views
Merge sorted lists
I have a few .txt files (in the same directory) that look like this:
123 carrot
50 apple
13 tomato
5 potato
2 pear
and
100 carrot
10 apple
3 tomato
2 potato
...
