The tag has no wiki summary.

learn more… | top users | synonyms (1)

1
vote
1answer
1k 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
1k 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
1k 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
3k 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
185 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
459 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
1k 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 ...
5
votes
2answers
2k 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
551 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 ...
6
votes
6answers
7k 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 ...
4
votes
4answers
22k 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 (ID3 tags), but all are located in the same folder. I wish to automatically organize all of them according to this metadata. Is ...
4
votes
2answers
4k 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
255 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 ...
8
votes
3answers
8k views

fatsort for Windows 7 [closed]

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
619 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
36 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
658 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 ...
2
votes
4answers
5k 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
929 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
63 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
179 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
543 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 ...
2
votes
1answer
568 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
3k 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
280 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
1k 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
895 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
299 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, ...
26
votes
7answers
19k 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
468 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
310 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
512 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
688 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 ...
14
votes
5answers
13k 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 ...
2
votes
2answers
912 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
15k 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
1k 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
507 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
841 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
7k 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? ...
2
votes
3answers
3k 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
5k 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 ...
17
votes
2answers
38k 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
9k 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
2k 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)
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 ...
1
vote
1answer
3k 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 ...