The sort tag has no wiki summary.
3
votes
4answers
1k views
How to reorder a large number of columns?
I'm looking for a pipeable one-liner to reorder a large number of columns (where manually entering the column numbers in e.g. an awk command such as awk '{print $3,$2,$1}' is not feasible). The order ...
2
votes
3answers
713 views
sorting filenames numerically when they have non-numeric prefix
I have files in the following format: x1 x2 ... x10 x11 ... x101 ...
I want to rename these files, so they all have the same name length: x001 x002 ... x010 ...
I can do this with files, that don't ...
2
votes
6answers
133 views
sort ls output by users
On Linux, is there a way to sort ls output by users? What I try to achieve is something like this:
user_a file1
user_a file2
user_b another_file
user_c this_file
user_c ...
2
votes
6answers
2k views
Get text-file word occurrence count of all words & print output sorted
I had a command which would work through a text file, count all the occurrences of the words and print it out like this:
remy@box $˜ magic-command-i-forgot | with grep | and awk | sort ./textfile.txt
...
2
votes
4answers
149 views
append string where it belongs in sorted file
Suppose I have a sorted file, named sorted.txt, like this:
beautiful
easy
fast
functional
handy
Now, doing echo fine-grained >> sorted.txt will put "fine-grained" at the end of the file, ...
2
votes
2answers
56 views
Select greatest numbered filename
Simple requirement but can't find anything online which can achieve it.
I have a list of dated files as below...
filename_20120101.dat
filename_20120102.dat
filename_20120103.dat
I ...
2
votes
2answers
390 views
Sort by regular expressions
I've got a set of POSIX regular expressions*
^BEGIN:VCARD\r$
^VERSION[^A-Z]
^FN[^A-Z]
^N[^A-Z]
^NICKNAME[^A-Z]
^EMAIL[^A-Z]
^X-\([A-Z-]*\)
^TEL[^A-Z]
^ADR[^A-Z]
^ORG[^A-Z]
^TITLE[^A-Z]
^BDAY[^A-Z]
...
2
votes
2answers
620 views
Issues of using sort and comm
I was trying to find the intersection of two plain data files, and found from a previous post that it can be done through
comm -12 <(sort test1.list) < (sort test2.list)
It seems to me that ...
2
votes
2answers
156 views
Move one file at a time based from specific number in the files
Based from this question, The HTML files date format has been changed. All of the HTML files have the date such like below:
20110730dateishere
dateishere is intentionally added by me in the files, ...
2
votes
1answer
65 views
How can I list my `at` jobs by date?
I am using
atq
command, but I need to list my at jobs by date.
How is that possible ?
2
votes
2answers
45 views
Specify the sort order with LC_COLLATE so lowercase is before uppercase
Given the file:
$ cat file
1
a
C
B
2
c
3
A
b
By default sort will:
$ sort file
1
2
3
a
A
b
B
c
C
With LC_COLLATE=C so will sort in uppercase letter before lowercase:
$ LC_COLLATE=C sort file
1
...
2
votes
2answers
58 views
sort a file based on length of the column/row
I need to sort a file based on the number of chars in the first column.
I have no idea on how to go about this. (On Linux, so sed/awk/sort is available).
An example:
.abs is bla bla 12
.abc is bla ...
2
votes
2answers
154 views
Reorder folders on FAT32 drive
My car can read MP3 files from a FAT32 flash drive. I have a folder for each artist on the drive, then MP3 files in those folders.
However the car does not read the folders alphabetically, but by the ...
2
votes
1answer
1k views
Linux sort last column
I'm running a script (that I have no control of) to get the following output.
I want to sort by the last(3rd) column. Each column is separate by spaces, and the 2nd column includes spaces/symbols.
...
2
votes
2answers
51 views
Sort lines by unicode value
I'm trying to sort a text file linewise by their Unicode values. As far as I can tell, this means numerals first, then letters, then CJK-Ideographs. However, sort (with LC_ALL=C) fails horribly at ...
2
votes
0answers
27 views
Unexpected ordering of strings in `sort` command [duplicate]
I'm trying to sort a text file using certain columns in the file as a sort key. Since the file doesn't have separators and fields sometimes stick to each other, I have to convert spaces to some ...
1
vote
2answers
109 views
`echo -e 'Q\ns\nV' | sort` doesn't sort
Why do :
$ echo -e 'Q\ns\nV' | sort
outputs
Q
s
V
without changing the order of my list (taking in account the lower/uppercase ?)
1
vote
3answers
89 views
Sort with unequal whitespace in first column
I need to sort this list by name, high temp and low temp:
Kuala Lumpur 78 56
Seoul 85 66
Karachi 95 75
Tokyo 85 60
Lahore 85 75
Manila 90 85
I figured since whitespace is the delimiter for a column ...
1
vote
1answer
694 views
The simplest method to count lines matching specific patterns, including '0' if line is not found?
I have very big logs (several gigabytes per day), that can (but do not need to) contain specific lines. I have to count the number of occurences of every one of these lines on a daily basis.
I have a ...
1
vote
2answers
675 views
Sorting by date
Original:
Jan 23 2011 10:42 SOMETHING 2007.12.20.avi
Jun 26 2009 SOMETHING 2009.06.25.avi
Feb 12 2010 SOMETHING 2010.02.11.avi
Jan 29 2011 09:17 SOMETHING 2011.01.27.avi
Feb 11 2011 20:06 SOMETHING ...
1
vote
2answers
39 views
How to remove duplicate entries from a file?
I have a comma-separated list of domain-names in a file; unfortunately there are duplicate entries for some domain-names.
Is there a way to find and remove the duplicate entries from the file?
The ...
1
vote
3answers
110 views
How to sort and join at the same time?
I have 2 files, one having 2 columns, another having 1 column. The second file is sorted using sort -u. Now the task is I need to join this column with the first column of the first file, which is not ...
1
vote
3answers
121 views
Reading a directory in shell script
I want to read a numbered directory which is under a path, into a variable in shell script.
The paths are something like this:
.../releases/R1/...
.../releases/R2/...
.../releases/R3/...
Each time ...
1
vote
1answer
155 views
Sort -u Function Command Not Working
As you can see in the picture attached
screen shot
After I used the sort command to sort a VERY large wordlist file I then split them up using the Split command. From there I confirmed that the ...
1
vote
3answers
139 views
Numerically sorting files [duplicate]
Possible Duplicate:
List files sorted numerically
How can I sort this according to the number of last field? I tried with sort -t ' ' -k9,10n:
-rw-r--r-- 1 root root 440 May 14 08:52 ...
1
vote
1answer
38 views
Sort aligned columns
I have a program which output looks like this
# Status VAL1 VAL2 Description
1 some text 2.5 4.4 Some long other text
5 some text 2 14.5 2.0 Some long other ...
1
vote
2answers
220 views
Deleting specific lines and duplicates from a 11gb wordlist text file
I have an 11gb wordlist file which is already sorted as each word is on its own line.
I need to remove duplicates and lines starting from 077.
I guess I need to run sed and sort -u together but I ...
1
vote
3answers
227 views
strange problem: join: file 2 is not in sorted order
sort flash_int_list.txt|join finish_comm - > t1
join: file 2 is not in sorted order
I have sorted flahs_int_list.txt
but it still says file 2 is not in sorted order
what is wrong ?
the ...
1
vote
3answers
662 views
Script to show number of files (by file type) in a directory?
I want to show this kind of statistics about a particular directory:
$ myscript.sh
.c 34265 files
.h 17866 files
.cbl 1804 files
.pco 389 files
[...]
Is there a tool that can do this?
Here is my ...
1
vote
1answer
128 views
How to match 2 large file and print the difference in shell script
I have 2 files.
File1 has 400k numerical records.
e.g:
1
2
3
4
5
6
.. and so on
File 2 also has 420k numerical records.
e.g:
1
2
3
4
6
.. and so on
Both these file are in unsorted manner. I want ...
1
vote
1answer
89 views
Sorting by one column then the
Say i have a output file with following:
010513 08:04 ROUTER1 192.168.1.1 68.130.5.10 HIT(1)
010513 08:04 ROUTER1 172.168.1.1 28.130.5.10 HIT(1)
010513 08:04 ROUTER1 122.168.1.1 ...
1
vote
2answers
311 views
Creating recursively sorted RAR archive
For various reasons I decided to use RAR archive to store some data, instead compressed tar.
Happy with decision, except for one thing: I can't find a way to store files sorted. Order of files is ...
1
vote
3answers
56 views
another question with sort in bash [duplicate]
How can I ignore the space in "Kuala Lumpur" when sorting this list? I cheated it by tabbing the columns and sorted on the tab which gives me the right results but I would like to know how to deal ...
0
votes
1answer
231 views
Sort a file based on 1 column [duplicate]
Possible Duplicate:
how do you sort du output by size?
I have a text file generated from the output of
du --max-depth 1 -h > sizeOfHomeFolder.txt
It's contents are in this format:
$ ...
0
votes
1answer
62 views
Remove repeated words with suffix in a file
I have a list of records in a file as in below example
word_word1
word_word1_acc
word_word2_acc
word_word3_acc
word_word4
I need to remove only word_word1_acc line in the file as it is only a ...
0
votes
1answer
64 views
How does -k flag work in sort command? [duplicate]
I have got a dataset like this:
manufacturer,model,year,mileage,price
plym fury 1970 73 2500
chevy malibu 1999 60 3000
ford mustang 1965 45 10000
volvo s80 1998 102 9850
ford thundbd 2003 15 10500
...
0
votes
0answers
40 views
problems with tab order in Kate
I use the standard Tab Bar plugin in Kate v3.8.5 on Fedora 16 and when I rearrange my tabs with my mouse (haven't found a way to do it with the keyboard), and then switch tabs with Alt+Left and ...
0
votes
1answer
89 views
How to sort a Diary?
Diary has entries with month and day, no years, in the format %D_%M.tex but index in wrong order because of wrong sorting and poor filename -format. How should I call my Diary -entries to get them ...
-1
votes
3answers
62 views
Sorting IP address according to the second field in file
in my ksh script I need to add the following task ( OS - linux/solaris )
I have the following file
more test.txt
/etc/backup/app 172.1.120 172.110.120
/etc/backup/app 172.1.120.12 ...
