The sorting tag has no wiki summary.
1
vote
1answer
288 views
Sort text file of blocks
There are plenty of tools that will sort a text file on the assumption that the unit of interest is the line, but are there any that work on blocks?
Example:
name = Mercury
order = 1
mass = 0.06
...
1
vote
1answer
727 views
specify the sort order in “copy /b *.dat foo” in Windows cmd
Normally, when I do a copy /b *.data foo in Windows cmd, the *.data files are catenated in the sorted order into the destination file foo. This matches my desired behavior.
However, I just met a ...
0
votes
1answer
2k views
Excel / VBscript: Need to sort columns with a header
I have a vbsctipt that opens an Excel(2007) document copies the used range from two sheets (minus the header on sheet 2) puts it all on 3rd sheet. I then need to sort that data using the header. I ...
0
votes
1answer
914 views
Autosort microsoft excel worksheet
Can I configure (possibly with scripts) Excel to automatically resort a table every time an entry is updated?
0
votes
3answers
788 views
Sorting is not consistent using the Unix command 'sort'
I'm running the command:
zcat [File] | sed "1d" | sort -t $'\xE7' -k [field to be sorted] > [file].sorted
When I run this on File A, sorting on field 1, I get the following result:
11622400 , ...
2
votes
2answers
2k views
How to sort ls by column in Ubuntu via piping to sort?
I'm a Linux newbie trying to learn how piping works in the Ubuntu terminal. I tried to sort by file size:
ls -al | sort -k5
The files were listed in this order:
drwx------ 19 min10 domain users ...
1
vote
2answers
169 views
How to Find Most Common or Frequent Files In Directory?
I have a directory with lots of images(100,000+). Many of these are
duplicates/identical images but obviously all have different filenames. I need to find the images that have the most duplicates in ...
0
votes
1answer
419 views
Windows 7: View column headers in Windows Explorer when in icon view
In windows 7 is there a way to view the column headers in Windows Explorer when you are in icon view? When in details view you get a list of column headers that makes it easy to filter or sort by ...
4
votes
3answers
961 views
Windows explorer: sort by date modified
Is it possible to properly view the contents of a folder sorted by modification date in Windows explorer (Windows 7)?
I can sort by the date modified column, but folders and files are seperated. I ...
4
votes
2answers
1k views
GNU sort by case-sensitive
The sort utility in Ubuntu 10.04 (Lucid) always sort by case-insensitive, just like if you specify --ignore-case to it.
The two sort just give the same result:
echo -e "c\nb\nB\na" | sort
echo -e ...
1
vote
0answers
479 views
Path Finder: How to sort files by date, but folders by name?
This is possible in Total Commander.
How can I make such separate sorting in Path Finder as well?
I like to sort files by date, but I don't see any point in sorting folders this way - they just jump ...
5
votes
4answers
6k views
Outlook 2010 Unable to Categorize Messages
I am unable to categorize messages in my inbox. What I'm talking about is the ability to assign a color category. I'm accustomed to being able to just click the icon in the ribbon of the open message ...
2
votes
3answers
14k views
Automatically sort music files into folders by album/artist names
I have a large collection of music files (let's say mp3), with metadata, but all are located on the same folder.
I wish to automatically organize all of them according to their meta data inside ...
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?
0
votes
4answers
191 views
Is there a way to do Drag and Drap sorting of emails in Outlook?
I'd like to be able to manually sort emails in a particular Outlook folder instead of having it auto-sort by some particular column.
Basically, for emails that I need to do some sort of follow up, I ...
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 ...
1
vote
3answers
465 views
Why does my exchange message filtering rule not work?
I have two rules set up to sort incoming bug reports. The first is specific to a single device:
Apply this rule after the message arrives
sent to SMS Distribution
and with ...
0
votes
1answer
35 views
Is there a blog tool with support for tagging posts, only displaying posts with certain combinations of tags, and LaTeX? [closed]
What I want:
A blog.
I can tag posts, e.g. "A" or "B" or "all," and then you can either 1) click to only view posts tagged "A" or "all" or 2) even more ideally, I can set it so you automatically see ...
1
vote
6answers
553 views
Best way to manually sort random text files?
I have about 1000 text files and I need to view each, and move it to a folder if it's the correct one. I can only do basic sorting by length/size, and I can't grep because the text is random. How can ...
1
vote
4answers
3k views
Merging and sorting multiple files with “sort”
I have a bunch of text logfiles in the following format:
ID (17 characters)
Timestamp (14 characters YYYYmmddHHMMSS e.g. "20060210100040" -> 2006/02/10 10:00:40)
Random data (? ...
7
votes
6answers
757 views
Joining text files with 600M+ lines
I have two files, huge.txt and small.txt. huge.txt has around 600M rows and it's 14 GB. Each line has four space separated words (tokens) and finally another space separated column with a number. ...
1
vote
2answers
59 views
When your field-terminating char appears within field values
I've had a very colorful morning learning the innerparts of Linux's sort command, and have come across yet another issue that I can't seem to find an answer for in the documentation.
I'm currently ...
1
vote
1answer
152 views
SORT empties my file?
I'm attempting to sort a csv on my machine, but I seem to be erasing the contents each time I use the sort command. I've basically created a copy of my csv lacking the first row:
sed '1d' ...
6
votes
1answer
428 views
Mail.app - What sets sort order when adding To addresses by typing Group name?
Using Mail.app in Mac OS X (10.6.3) I'm seeing apparently random sort order when sending a email to a group. Not a major issue but you'd think it be alphabetical?!?
To reproduce:
Compose New ...
0
votes
0answers
2k views
Sorting by Folder and Received in Outlook 2010
I want to sort my Unread Mail folder by Folder and within that by Recieved (oldest on top).
I've found that by clicking the "In Folder" header, holding down Shift and clicking Received twice I can ...
1
vote
1answer
432 views
Other language Sorting(like hindi, not english) for Excel sheet column
How can I sort excel sheet column for other languages like hindi(not english)?
1
vote
2answers
2k views
Windows “save” dialog listing files in reverse alphabetical order by default
Imagine this: no matter which software, when I hit "SAVE", the file explorer dialog that appears is listing my files in reverse-alpha order. This happens by default on all folders and is just an ...
1
vote
0answers
246 views
Sorting in Pivot Table on how data is summarized, not just the value
Often I am creating pivot tables that summarize some count by some category. Let's say I am counting Yes/No responses by some category. I usually add the count field and display it as a "% of row", ...
0
votes
1answer
900 views
How do I salvage files from the lost+found folder?
Well, I screwed up my external hard drive and now everything is in the lost+found folder. I can barely look through it because there is several tens of thousands of files (buncha inode things) and a ...
2
votes
4answers
668 views
Sorting emails with no To: tags in Outlook
Lately people at work have been sending with mailing lists in blind copies instead of just sending to the mailing lists. I think the intent is to prevent people from accidentally replying to all, but ...
0
votes
4answers
288 views
need advise on using sort command in Linux
How to sort a file using sort command..
I would like to sort the file based on 2nd field which is seperated by "," as a delimiter
Ex:
filename1, 465, output_file1,
filename2, 300, output_file2,
...
20
votes
10answers
13k 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.
2
votes
2answers
427 views
Excel 2003 Alphabetic Sort Order Is Not My Idea of Alphabetic
I have an Excel 2003 spreadsheet that I'm sorting on the first column, which is formatted as Text. The sort order is strange. Here's a "sorted" example. I've highlighted the anomaly.
120-BDXX
...
0
votes
2answers
256 views
sorting two columns
I'm trying to use the sort command (5.97) to sort one column of data and then another.
Right now, I'm doing:
> ls test/2/*.jpg | sort -t- -k1 -g -s
test/2/0-0.jpg
test/2/0-10.jpg
test/2/0-1.jpg
...
0
votes
2answers
394 views
How to sort images based on their content?
I have a bunch of images (screenshots), that I would like to sort automaticly in subfolders.
Since these are screenshots, I was thinking that I could program something that would read each jpg, check ...
0
votes
2answers
545 views
XP orders files backwards
Windows XP sorts everything alphebetically by name, except that it does it backwards. As it folders are always at the end and then ordered from Z-A. This is not only in Windows Explorer (which is easy ...
11
votes
4answers
8k views
In bash, how to sort strings with numbers in them?
If I have these files in a directory
cwcch10.pdf
cwcch11.pdf
cwcch12.pdf
cwcch13.pdf
cwcch14.pdf
cwcch15.pdf
cwcch16.pdf
cwcch17.pdf
cwcch18.pdf
cwcch1.pdf
cwcch2.pdf
cwcch3.pdf
cwcch4.pdf
cwcch5.pdf
...
1
vote
2answers
738 views
Is there a way to preserve or remember sort-by preferences for different folders in column view in Mac OS X?
For example, I would like to have folders in column view, and to have Folder 1 always to show files sorted by kind, and Folder 2 always to show files sorted by date created. I'm running Leopard, with ...
4
votes
3answers
9k 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 ...
2
votes
1answer
970 views
Outlook 2003: How to group by flag AND sort by date?
I'm trying to get Outlook 2003 to do the following:
Group the emails in my Inbox by FLAG and then sort by DATE.
This SHOULD be accomplished by the following settings:
It seems to work, as I get ...
1
vote
2answers
482 views
How can I remove Vista folder tabs?
How can I remove the sorting tabs COMPLETELY in folders in Vista Home Premium SP2 OS?
You can see the details in the below image:
0
votes
2answers
695 views
Windows Task Manager process ordering
Is there any rhyme or reason to the default ordering of the Windows Task Manager processes tab under Windows XP? It seems totally random.
And when sorting by CPU or memory, why do they default to ...
3
votes
2answers
5k views
How do I change the default sort order on Windows Explorer and the File Dialogs
My file dialog shows files sorted by date and I want it to sort alphabetically by filename.
0
votes
4answers
4k views
iTunes 9 not sorting albums by track order consistently
I have my iTunes library set to sort by music by Artist, then album . For most of my albums this will also sort the albums in the correct track listing order (using the track number tag).
Except for ...
2
votes
1answer
1k views
How do you sort bookmarks in Safari alphabetically?
I have a lot of bookmarks in Safari and I would like to sort them alphabetically. It's a pain to do it manually, and I don't seem to find a "Sort alphabetically" menu option.
Is this at all possible?
...
1
vote
3answers
2k views
How to sort by date in filename?
I have a bunch of meeting minutes, where the filename is the date the meeting took place. I would like to sort by this date.
The dates in my case are of the following form:
01.01.2009.doc
...
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 ...
14
votes
2answers
22k views
How to UNIX sort by one column only?
I know that the -k option for the Unix sort allow us to sort by a specific column and all of the following. For instance, given the input file:
2 3
2 2
1 2
2 1
1 1
Using sort -n -k 1, I get an ...
1
vote
4answers
6k 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 ...
1
vote
4answers
1k views
Sorting files (images) and then renaming them automatically according to the sort
We want to sort image files in a directory and want them to renamed according to the order we gave.
Is there a tool that can do this?
(os: windows xp)
