Sorting is any process of arranging items according to a certain sequence or into different sets.

learn more… | top users | synonyms (1)

0
votes
0answers
18 views

Why am I unable to sort data in Excel?

Here is what my spreadsheet looks like: I am trying to sort these invoices first by type (Column B) then date, and finally by amount (which shouldn't apply, but why not). I have checked for ...
0
votes
0answers
25 views

why is my sort slower with more ram?

System specs below. I recently purchased 2X4 RAM: Corsair XMS3 8 GB (2 x 4GB) 1333 MHz PC3-10666 240-Pin DDR3 Memory Kit CMX8GX3M2A1333C9 I already had 2X2 in there for a total of 12GB: Corsair ...
0
votes
0answers
4 views

Ignore certain characters while sorting data in libre/office calc

I have a list of transliterated chinese terms in a table showing Wade-Giles (W.-G), chinese characters and Pinyin transcription. Example, (sorted W.-G column only): P'u Te Ssu P’u t’uo-shan Pai ...
1
vote
1answer
21 views

spreadsheet: sorting by the first n characters of the entries of a column then by another column

Is there any way to sort an OpenOffice Calc spreadsheet by the first n characters of a given column then by another criterion? For example suppose that we have the following 4*2 spreadsheet (Note ...
1
vote
2answers
26 views

Trying to cat the result of piped commands

I have a folder of files that are named list20140801.txt list20140802.txt .... I'm trying to do this ls | sort | tail -3 | cat But it is just giving me the file names, not cat'ing them.
0
votes
2answers
42 views

How to sort columns in Excel so that only one value appears in each row?

Say I have a a spreadsheet with the following data: A B C D --------------------- 2 1 0 2 3 2 1 4 5 3 3 6 7 5 6 8 11 8 10 10 ...
0
votes
1answer
14 views

Sort piped to uniq unexpected output

I have a file that looks like this: "string",192.168.1.0,,TX,192.168.1.2,,,100,0,0,10,10,10,, "string",192.168.1.0,,TX,192.168.1.1,,,100,0,0,10,10,10,, ...
1
vote
1answer
37 views

Case insensitive sorting

Vim's default sort is case sensitive, and produces results like this: A B a How can it be made case-insensitive, to produce the following result given the same input? A a B
0
votes
3answers
60 views

Excel filter duplicate values in column A and filter out rows which have column C blank

Total n00b here. How to filter duplicate values in column A and filter out rows which have column C blank. I have 2200 rows in Col A (the first 1400 rows also have data in Col B & C, the next ...
1
vote
0answers
36 views

“Sort Lines” disabled in Sublime Text

I'm wondering why I can't click on Edit > Sort Lines in my Sublime Text 3 ? I often use it and I don't think I've done anything which could disable it, so I don't know where to search... What ...
0
votes
2answers
48 views

is there a way to sort files in a directory by view count? Win 7

As per the title, can files in a directory be sorted by view count in windows7 ? I have a folder with a lot of videos. I want to delete bottom 20 least viewed videos. This would require me to sort ...
0
votes
0answers
41 views

How can a Macro sort dates from oldest to newest?

I'm doing account statements in a bank and I need to be able to make them fast, so I am using macros for making this process. However, there is a step that I always have to do that a macro won't let ...
0
votes
0answers
21 views

Changing the order Of Dropbox photos

The order of the photos we have in dropbox is alphabetical according to caption rather than in the order in which they were taken. How do I change the order?
0
votes
1answer
30 views

How to calculate occurrences of some word in table

How can I calculate how many times occurrences any of these "value" Column for example I need: N 97 5 N 72 7 N 83 22 N 70 3 N 76 8 Z 34 7 N 85 2 ... ... ... and sorted ...
0
votes
0answers
39 views

If sort created temporary files, does it mean it's out of RAM memory?

I was sorting a large file (101MB - about 700MB after unzipping) using sort command on server that has 48GB of memory. It was the only heavy job it was doing at that time. However I noticed that sort ...
0
votes
1answer
38 views

What's the strategy used by sort when field not found?

I got a file named test, its content is like 111 222 11 22 111 223 12 22 33 11 2 25 222 331 11 2 33 2 1 33 33 22 33 I used: sort -bk2.3 test But the result confused me, those lines which doesn't ...
0
votes
2answers
49 views

Why “ sort file > file ” would remove all the content of that file?

Today I'm learning sort command. I find that, I can use sort file1 > file2 To inject the sorted file into file2 But when I use sort file1 > file1 file1 become empty! Why?! I know I ...
1
vote
0answers
40 views

save folder sort setting in windows 7

I have Image folder and sort my image by date. Everytime I open a folder, windows sorts all file by name and then green bar fill address bar. after that all image sort by date. ...
0
votes
1answer
57 views

Linux: Sort /etc/fstab by the mountpoint field

On linux, how would you sort the /etc/fstab file by mountpoint? I'm interested in sorting a section of fstab (whatever is mounted under /x) in such a way that parents are mounted before its children ...
0
votes
1answer
14 views

Inverting Music Folder Sorting

Due to various circumstances I have a large collection of .MP3 files in folders by artist, then album. This of course leads to issues with albums with more than one artist on them which end up spread ...
0
votes
1answer
23 views

Excel 07 - declaring and sorting chunks of arbitrary size

Let's say I have a list of Abbreviations: As you can see, the only layout "rule" is a blank line between entries. I should now like to sort them by their abbreviation: Using Excel07 and having ...
5
votes
1answer
3k views

Sorting lines in Notepad++ without TextFx plugin

Current version of Notepad++ is 6.6.3. Version 6.5.2 is the first, that introduced native (without plugin) sorting function to Notepad++. At least that's what they claim. Because, even though we're ...
0
votes
0answers
45 views

What is the best order of item fields in for different group with various template zabbix?

In my company, we have about 30 servers which i monitor them by zabbix. Some of them are Windows base OS and some others are Linux (CentOS, Debian, Ubuntu) OS base. Basically i create a Template, ...
0
votes
3answers
325 views

How can I sort my data while keeping paired rows together?

How can I pair two rows on a spreadsheet, so that for each data entry I can sort the matrix but the pair of rows moves as a single list of data, retaining the structure of the two rows? For example: ...
0
votes
1answer
35 views

Can I remove the original file while running “sort”?

I'm sorting a huge file, around 400 gigabytes. I'm running out of the disk space and I must do something quickly. Let's assume the original file is called original_file. So I execute (simplified) it ...
1
vote
1answer
71 views

Sorting Dates in Excel By Month

My boss has given me a job in which he has given me the names of customers and their wives who has bought our products from 2 to 3 regional offices. My boss wants me to format all this data into one ...
0
votes
1answer
23 views

Sorting and showing the most repeated row (value)

I have a sheet containing over 200k+ rows with values like this, 10.10.10.10 11.11.11.11 12.12.12.12 10.10.10.10 10.10.10.10 I want to be able to show the most repeated row at the top or extract it ...
0
votes
1answer
28 views

getting todo.sh to sort due items first, then by priority

How can I get todo.sh to put items that are due: today first, then after that sort the normal way (A-Z priority then everything else)? There's this solution, but then you lose A-Z priority and have ...
0
votes
0answers
33 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 ...
2
votes
0answers
171 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 ...
0
votes
0answers
33 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 ...
3
votes
3answers
98 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
3answers
49 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
316 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
48 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
38 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. ...
1
vote
2answers
118 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 ...
0
votes
0answers
25 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
74 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
29 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 ...
0
votes
0answers
20 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
158 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: ...
2
votes
2answers
2k 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
2answers
75 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 ...
0
votes
0answers
161 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: ...
-1
votes
1answer
49 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 ...
1
vote
1answer
328 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
201 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
1answer
143 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 ...
0
votes
1answer
100 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 ...