The tag has no wiki summary.

learn more… | top users | synonyms (1)

3
votes
3answers
46 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
0answers
10 views

LibreOffice Calc dynamic text sort

Given the following table: A B 1 AA AA 2 HH BB 3 BB HH 4 II II 5 UU LL 6 LL UU I need to sort the values of column A to B dynamically, using only ...
3
votes
0answers
65 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 ...
5
votes
2answers
643 views

ls version number sorting Mac OS X

Is there an equivalent to ls -v in Mac OS X that will do version number sorting? In Mac OS X, ls -v does NOT do version number sorting, but the Finder seems to.
0
votes
0answers
9 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 ...
31
votes
8answers
39k 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): ...
1
vote
2answers
272 views

Excel: Remove lines with duplicates in column B, based on data in Column A

I need to find duplicates in Column B; and then delete the entire line if the the value in Column A is the number 4. There are lines that need to be kept and have "4" in Column A. A B 1, John 4, ...
0
votes
3answers
38 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
43 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
16 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 ...
0
votes
0answers
25 views

I'm trying to list size of folders plus selected files on a portable disk

For the purpose of finding the location of my data among many portable disks, I'm trying to create plaintext lists of the contents of all folders and files of certain extensions and sort them by size. ...
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
2answers
27 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 ...
10
votes
1answer
12k views

How to sort an Excel spreadsheet columns by row contents?

How do I sort the columns of an Excel spreadsheet? The Sort command from the Data menu only allows me to sort rows by the value of a column. I want to sort the columns alphabetically by the contents ...
1
vote
1answer
123 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 ...
0
votes
3answers
6k views

My excel spreadsheet won't sort/alphabetize properly

I have a spreadsheet with multiple columns and over 4000 rows. I need to sort, then alphabetize my report and everytime I do, there are 43 rows that do not sort with the rest of the report; they go ...
0
votes
0answers
10 views

How to sort bookmarks in Scribus by page?

By default bookmarks in a Scribus document are sorted in the order they are created by the user and must be manually sorted. How can I sort the bookmarks defined in a Scribus document by page number? ...
1
vote
1answer
26 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
24 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 ...
1
vote
2answers
387 views

batch - File last modification time with seconds

I want to know when a file has been modified for the last time. I can get these infos using the following batch script: FOR %%i IN (myfile) DO SET modif_time=%%~ti The problem is that I need ...
0
votes
0answers
12 views

Adding custome metadata to PDF using Acrobat X

I have some PDF tax files that I would like to separate by year. However, the year created / modified isn't necessarily the year I want to categorize it under. How can I add a "year" field to the ...
0
votes
1answer
62 views

SortTV perl script error

I'm trying to use a perl script named SortTV (http://sourceforge.net/projects/sorttv/) Every dependencies is installed but I got an error & can't understood it... It's not a specific problem of ...
0
votes
1answer
80 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: ...
3
votes
2answers
1k 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 ...
0
votes
2answers
34 views

How to customize folder grouping in Windows 7?

I wonder, how to customize folder grouping in Win7? You can group them by Name, Date, etc — but how to create custom groups? Like, I have 30 folders on a disk, and i want them to be grouped under ...
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 ...
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 ...
0
votes
0answers
77 views

Excel 2013 - Is there a macro to sort and split the contents of a spreadsheet

I know there any many similar questions to this, but none seem to match exactly... I have a basic Stock List, and want to help to speed up stocktaking, so am looking to create a macro to do the below: ...
3
votes
1answer
362 views

Sorting XML files so that differences can then be found

I need to compare two XML files, each of which is about 13,000 lines long. Sadly the code that generates these files doesn't generate the data in the same order each time (the data comes from a ...
1
vote
0answers
81 views

In an Ubuntu “open file” dialog, how to sort in alphabetical order by default?

I just cannot find any way to just set the alphabetical order in an "open file" dialog in Ubuntu. Here is my problem : I use Libreoffice on Ubuntu. In Libreoffice, the relevant parameter is set on ...
-1
votes
1answer
35 views

Issue with Outlook 2013 rule condition “From Specific Address List” [closed]

I am an exchange administrator and I have a user who wants to filter mail based on the first letter of the sender's last name. The only way that I have found to do that is creating a server side ...
11
votes
3answers
1k views

Sorting Excel column by IP address

I have a fairly large (over 200 row) Excel spreadsheet that lists items in my network (i.e. printers, servers, workstations, network projectors, etc), and one of the first columns is the IP Address ...
1
vote
1answer
123 views

Windows Explrer Sorting order for special characters?

What is the sorting order used in Windows Explorer? I was specifically wondering what special characters sort after the alphabets? As far as I can tell (test), all special characters seem to be ...
0
votes
0answers
141 views

Using VBA to sort cells to match the values in an adjacent column

What I would like to do is write a macro that sorts the values in the range B3:D9 on the left side of the linked image to produce the intended result (shown on the right side). For every value in ...
-4
votes
4answers
2k 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
1answer
65 views

Unable to sort selected cells within the Table in Excel 2013

I created a Table in Excel 2013 but I want to sort only selected cells. The table range is A1:I200 but I only want to sort A150:I200. I tried selecting the cells, right click, sort, it sorted the ...
7
votes
1answer
303 views

Windows 7 Recycle Bin sort by Date Modified

In the Recycle Bin, I sorted by 'Date Modified', but the result is not in the proper order. It was neither ascending nor descending. Other sorts (by Date deleted, size, item type) all work well. Does ...
0
votes
1answer
39 views

Sorting files in a folder into subfolders with a specific/maximum number of files

Im a bit of a noob on programming so i need some help. Im using windows 7 BTW i have several folders ; 0,A,B,C,D etc. each contains somewhere between 150 and 8000 files that start with the same ...
-4
votes
1answer
185 views

how do you ignore empty cells?

I'm using this function to rank data: =SUMPRODUCT(($B$2:$B$11>B2) / COUNTIF($B$2:$B$11,$B$2:$B$11&"")) + 1 This version assigns 1 to the highest value and sequentially increasing ranks to ...
0
votes
0answers
39 views

Itunes Smart Playlist - Sort by Descending Track Number

I want to create a smart playlist that will list an album by descending track number. I have a singles album in which I would like to add new singles as time goes on but I want to listen to the new ...
1
vote
1answer
67 views

How to disable message sorting on Thunderbird?

I keep constantly clicking the "subject" sorting button, when I want to click on the newest message. How can I disable the sorting completely? Perhaps by hacking the .exe file? It's pretty much ...
0
votes
1answer
62 views

Grouping and sorting rows in Excel based on single column

I have a list of families I need to sort by last name in column A. You can see that each child in the family has its own row. The problem is that when you apply sort by column A descending, it does ...
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.
1
vote
1answer
80 views

How do I quickly parse large ASCII files for matching records?

I have lots of files containing data records, stored as space-delimited ASCII files. Each record is a row containing numeric data, with some columns integer and others floating-point eg. 1 1 5711 4 ...
0
votes
1answer
39 views

Windows 8 sorting by name

I have a lot of documents and when I sorting them by Name, it looks like this: Story - descriptions.docx Story.docx Tale - descriptions.docx Tale - maps.jpg Tale v2.docx Tale.docx Why it is sorted ...
2
votes
4answers
10k views

Lotus notes 8.5 Inbox return to default sort and select next unread email

My default Lotus Notes (v 8.5.2FP2) Inbox is sorted by date/time (newest at top). I can then do the following steps: select a message (single click to select) click the 'Who' header: the sort order ...
1
vote
2answers
4k 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 ...
1
vote
1answer
155 views

In bash, what is a “general” and “string” numeric value when sorting?

According to "man sort" there are two ways to sort numerically: -g, --general-numeric-sort compare according to general numerical value and -n, --numeric-sort compare ...
0
votes
1answer
30 views

Sorting iTunes Artist field

I'm trying to sort out my music and I have a couple of artists who have changed their name or have an album with solo tracks and some in a group. Two examples are 'the game' and 'adam and the ants' ...
0
votes
1answer
487 views

How to sort only part of multiple columns in Excel

I want to highlight, for example, rows 5-15 across columns C, D, and E, and sort only that block in ascending order by one of the columns. The trick is that I want all included columns to follow suit ...