Hi,
I have this file (filex)
07-11-2003 10:11:12!cccc!ddd!eeeeeeee
07-11-2003 09:11:11!dddd!kkkkk!xxxxxx
09-12-2003 14:18:43!aaaa!bbbbb!cccc
where I need to sort it by date+time in this order:
09-12-2003 14:18:43!aaaa!bbbbb!cccc
07-11-2003 10:11:12!cccc!ddd!eeeeeeee
07-11-2003... (3 Replies)
hi everyone, i have a document where i have email addresess and names, i need to check if the email addresses are uniq, if they repeat erase one of them, how can i do that?
document sample:
aD00763357@cucei.udg.mx,ABRAHAM ANTONIO SEVERIANO
a199721111@cucei.udg.mx,ABRAHAM GONZALEZ... (4 Replies)
hello all, I have a file with two numbers on each line, comma separated. I want to sort the contents of the file in increasing order (smallest to largest) of the numbers on the second line. i.e:
23,3
25,2
27,12
to become
25,2
23,3
27,12
Does anyone know how I can do this?
Thanks... (2 Replies)
i ahve a file like:
*************************************
sree
122132
12321
***********************************
phani
21321
3213214
******************************
dddsds
213213123
23213213
*******************************
i want to sort the file with respect to name how we can do this... (1 Reply)
i have a data in afile like this
**************************************
sree
sree@yahoo.com
98662323432
*************************************
phani
phani@yahoo.com
98662323344
*************************************
i want to sort the file with respect to name.
how can i do this.
thank... (5 Replies)
I have the file as follow:
A: 60
B: 80
C: 40
D: 11
E: 100
I want to sort the file and get the output to file as follow:
E: 100
B: 80
A: 60
C: 40
D: 11
Could any one help me please? (1 Reply)
I'm trying to write a script that will look in an /exports folder for the oldest export file and move it to a /staging folder. "Oldest" in this case is actually determined by date information embedded in the file names themselves.
Also, the script should only move a file from /exports to... (6 Replies)
Hi,
I have two files, one of which I would like to sort based on the order of the data in the second. I would like to do this using a simple unix statement.
My two files as follows:
File 1:
12345 1 2 2 2 0 0
12349 0 0 2 2 1 2
12350 1 2 1 2 2 2
.
.
.
File2:
12350... (3 Replies)
Hi Guys,
My client (dear clients, I hate to love you) has the funky idea of sorting a 5G flat file.
Certainly enough, this is taking forever and also fulls the / of our machine.
Any idea of how we could proceed to make this a little bit more efficient?
Maybe by forcing sort to "stay in... (7 Replies)
Discussion started by: plmachiavel
7 Replies
LEARN ABOUT V7
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 specifed 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.
JOIN(1)