A little correction to my solution which works fine on my AIX box (do you try with nawk or gawk if they are available on your system ?) :
The following solution doesn't modify fields, so it must work with all versions of awk :
Jean-Pierre.
file format is
word filename no.of occurances
------------------------------
wish f3.txt 2
wish f2.txt 1
cold f1.txt 5
cold f2.txt 3
cold f1.txt 3
cold e.txt 3
gold f1.txt 7
gold f3.txt 3
rush e.txt 2
itz abt building a search index for every word in the files given as input
the... (1 Reply)
hey mate. ive got a sorting problem that i would like to share...
i made a script that sorts the bdf command and redirected the output to a file. the output of the file is:
691416 34% /
851552 7% /stand
7203048 31% /var
23637584 26% /var/adm/crash
2968864 ... (4 Replies)
Hai ,
In unix we are going to sort it out all the directories and files based on size of the file. For that we have to use this command ls -al | sort
+4nr. If we are giving this command means it will show all the records in a descending order....when I am checking one file bytes its... (4 Replies)
Hi,
Can someone tell me why the "LargeFile" is coming first before the smaller files. Is there any way to list the files based on size column.
ls -g| sort -k 4
-rw-r--r-- 1 user 6117910528 Apr 28 15:04 LargeFile
-rw-r--r-- 1 user 6136832 May 30 07:23 my_20080530.tar
-rw-r--r-- ... (2 Replies)
Hi all! I am new to Unix programming so bare with me please :).
I have saved the output of my results in a file called testfile which contains 3 columns a 15 rows.
e.g.
175 754 abvd
948 454 fewf
43 754 fewc
6 734 feww
xxx xxx xxxx I want to sort the contents of this file... (10 Replies)
1) I need to reverse sort the text from lit.csv (bellow) by the second column, then save the last five lines in a text file text.txt but I'm doing something wrong so any help would be much appreciated.
I've been trying to use this: sort --field-separator=; -b -k2g,2 lit.csv -o text.txt
2)... (4 Replies)
I have data like this in file
Now I have to sort using second column(usage) and i should get first column against it post sorting
please provide input (2 Replies)
Hi,
I have the following list:
42A
42AA
42B
42BB
42AAA
42BBB
49A
49AA
49B
49AAA
49BB
I need it to be sorted as following:
42A
42B (2 Replies)
Discussion started by: sairamtejaswi
2 Replies
LEARN ABOUT BSD
join
JOIN(1) General Commands Manual JOIN(1)NAME
join - relational database operator
SYNOPSIS
join [ options ] file1 file2
DESCRIPTION
Join forms, on the standard output, a join of the two relations specified by the lines of file1 and file2. If file1 is `-', the standard
input is used.
File1 and file2 must be sorted in increasing ASCII collating sequence on the fields on which they are to be joined, normally the first in
each line.
There is one line in the output for each pair of lines in file1 and file2 that have identical join fields. The output line normally con-
sists of the common field, then the rest of the line from file1, then the rest of the line from file2.
Fields are normally separated by blank, tab or newline. In this case, multiple separators count as one, and leading separators are dis-
carded.
These options are recognized:
-an In addition to the normal output, produce a line for each unpairable line in file n, where n is 1 or 2.
-e s Replace empty output fields by string s.
-jn m Join on the mth field of file n. If n is missing, use the mth field in each file.
-o list
Each output line comprises the fields specified in list, each element of which has the form n.m, where n is a file number and m is a
field number.
-tc Use character c as a separator (tab character). Every appearance of c in a line is significant.
SEE ALSO sort(1), comm(1), awk(1)BUGS
With default field separation, the collating sequence is that of sort -b; with -t, the sequence is that of a plain sort.
The conventions of join, sort, comm, uniq, look and awk(1) are wildly incongruous.
7th Edition April 29, 1985 JOIN(1)