The tag has no wiki summary.

learn more… | top users | synonyms (1)

1
vote
2answers
705 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 ...
1
vote
2answers
163 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.
1
vote
2answers
84 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
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 ...
3
votes
1answer
184 views

Remember icon size, sort order, and sort options per-folder on Windows 7

Sometimes when I change the icon size in one folder, all other folders are changed, too. Sometimes they are unchanged: Sometimes when I change the sort order, all other folders change too, ...
3
votes
1answer
365 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 ...
2
votes
1answer
101 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 ...
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
1answer
28 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 ...
1
vote
1answer
127 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 ...
1
vote
1answer
83 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 ...
1
vote
1answer
186 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 = ...
1
vote
1answer
124 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 ...
1
vote
1answer
201 views

Command-line sort and copy text files to one single file renders an error

I stumbled on question 217394 which explains how to copy files sorted alphabetically into one single file. Trying to implement the command myself rendered the following error message: The system ...
1
vote
1answer
320 views

Automatic sort for excel worksheet

I want to create a to-do list in Excel that automatically sorts the to-do entries in a list, in order of ones to do first (closest deadlines). I would also like a section that shows the tasks for ...
1
vote
1answer
838 views

batch-rename filenames with numbers to sort alphabetically

I want to batch-rename files containing numbers, padding the numbers with zeroes. The goal is to sort numbered sets of files alphabetically in the correct order in any application. In a set of files ...
1
vote
1answer
237 views

How do I re-sort a list of files grouped by directory?

From within a DOS batch file, how can I crudely re-sort a text file containing a manually maintained list of source files, so those files listed (from the same directory) in the small example extract ...
1
vote
1answer
448 views

How Windows arranges files by date

In Windows 7 if I have files arranged by date on the desktop with newest being last, then files are automatically places at the end (i.e. right bottom) as I update them. The exception seems to be ...
0
votes
1answer
17 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
1answer
84 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: ...
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 ...
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 ...
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
501 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 ...
0
votes
1answer
526 views

How do I add the “Date Created” sort-by option to the shell in Windows 7?

I know how to add it via the context menu, but it never seems to be a permanent option. I would like it to show in all folders without having to continually go back through and add it. How can I ...
0
votes
1answer
171 views

How do I sort in Excel 2007 but do not go to the top of the list?

How do I sort in Excel 2007 but do not go to the top of the list? I have a filtered set of data many rows long. However, when I am deep in the list, and select to change the sort by method on one of ...
0
votes
1answer
89 views

Does any OS/app/library support Roman numerals in natural numeric sort?

In modern operating systems, a list of files named 1.jpg through 10.jpg is sorted with 10.jpg appearing after 9.jpg, as it should. But I don't know of any natural sort implementation that accounts for ...
0
votes
1answer
926 views

Sort doesn't work properly for cells with references to other cells

I have two tables in Excel 2010, the second table has the last column filled with cells that reference the last column cells from the first table: For instance, the value of the first cell in the ...
3
votes
0answers
69 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 ...
3
votes
0answers
413 views

Sorting mail in Thunderbird by both unread status and by date

Is there any way to make Thunderbird sort mail so that unread mail is always at the top and the e-mails are sorted by date in descending order persistently? Maybe an add-on that someone can recommend? ...
3
votes
0answers
189 views

Is there a way to keep the selection in Windows 2008 Explorer when changing the sort order

I nice feature of Windows Explorer up to Windows Server 2003 at least (I don't have easy access to Vista or Windows 7 to know when this was lost) was that you could select multiple files (or folders) ...
2
votes
0answers
81 views

How to sort Google Drive search results by title?

I find Google Drive very convenient as an online notebook to store my diary and records, that I can access anytime, anywhere. Now when I want to search for a particular string of text, the only ...
2
votes
0answers
437 views

Pivot table : absolute value of grand total in Excel

My grant total is generated by summing values of COLUMNS of ITEMS for a given SUBJECT (For each SUBJECT I have a list of ITEMS and I want to make a grand total of the values of these ITEMS). The ...
1
vote
0answers
83 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
vote
0answers
123 views

Music Library Sorting Issue

I'm using WMP for for managing my music library. Lately I noticed something. I was reorganizing my library and came across a strange -I mean annoying- behavior of WMP. The way WMP sorts Artists. ...
1
vote
0answers
27 views

Reordering file lines like other file (Unix)

Is there a tool (or option for sort) which will re-order lines of a file so that they are ordered like a key in another file? For example, I have a data file: T01F01475558 30 T01F022B3A17 31 ...
1
vote
0answers
180 views

make “sort by” permanent for specific folder

I have a folder where I store all my web icons in .png and .ico format. I set view to large icons and sort by to date modified -> descending. When I save new icons in this folder from web, I drag ...
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 ...
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
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 ...
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 ...
0
votes
0answers
26 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. ...
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? ...
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
0answers
80 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: ...
0
votes
0answers
148 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 ...
0
votes
0answers
41 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 ...
0
votes
0answers
167 views

How to sort a group of folders always on top?

I'm using Windows 7 Ultimate, and I'm trying to arrange (sort out) files in a big folder. What I have done (translated from my native language): Right click > Group files by: GROUPS, by TYPE. ...
0
votes
0answers
184 views

Changing default sort order in Windows 7 desktop search

If I do a search (usually, I'm looking for an email), the results are presented in date-modified order by default I can do Sort By / More... and select Date Received, then Sort By and select Date ...
0
votes
0answers
111 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 ...