sort won't eliminate any lines (except for duplicates). To sort correctly for the first two key fields, you need to do
Code:
sort -u -t "|" -k1,2
as dennis had. sort -n (or similar) won't do it if your first field has different lengths.
Filtering out the lines before sorting may be more efficient if you have many lines and most of them should be eliminated.
I have been using a procmail recipe for some time. I successfully include numerous INCLUDERC files. However, since each of these include files have become rather large over time, I started to try to organize better.
So where procmailrc once just had:
INCLUDERC=$PMDIR/original-filters.rc
... (0 Replies)
Hi to all.
I'm trying to sort this with the Unix command sort.
user1:12345678:3.5:2.5:8:1:2:3
user2:12345679:4.5:3.5:8:1:3:2
user3:12345687:5.5:2.5:6:1:3:2
user4:12345670:5.5:2.5:5:3:2:1
user5:12345671:2.5:5.5:7:2:3:1
I need to get this:
user3:12345687:5.5:2.5:6:1:3:2... (7 Replies)
#! /bin/csh
set pattern = ""
set deli = |
foreach i ( `cat pattern`)
set pattern = "$pattern$deli$i"
end
all i want to accomplish is create a string a|b|c, but instead I got an invalid null command error,
thanks for your help (1 Reply)
hi,
i have to put in my script a command that should tell me if the contents of two different paths are the same.
I thought to write an "if" command who makes the diff of two files which contains the `ls` of the folders and go on with the script if is not null, but i'm afraid of the fact... (13 Replies)
Hi ,
On my box everything works fine. But whenever I run command
It returns nothing as you see @(none) too.
Its very strange issue I have never noticed on any other system yet.
Any one have any idea about this.
Thank you (2 Replies)
Why does this not work?
echo 'find / -iname \'*katt*\' -size +500M 2>/dev/null'
How does this work? I have 5 single quotes. I though you needed an even amount of single quotes.
echo 'find / -iname \'*katt*\' -size +500M 2>/dev/null''
What is the trick to make it work with an alias? This... (4 Replies)
Hello everyone
I am doing a join command. Obviously, before I need two files sorted first. ( Both files have headers and have about 2 million lines each one )
The problem is, one of the files has null values in the key to sort (which is the first filed ). For example I have the original... (4 Replies)
Hi,
I have this script which gives me output as Invalid null command
set recent_file=`grep '^-.*xlsx$' $FTP_LOG |\
sed -e 's/Jan/1/g' \
-e 's/Feb/2/g' \
-e 's/Mar/3/g' \
-e... (6 Replies)
I am using ISQL command in ksh script.
Suppose if i get NULL value from the query which i run,how can i handle it?
I am getting a NULL result set and the following error is coming.
############### output of isql command for getting the sum of JEs ################
-----------
NULL... (4 Replies)
Discussion started by: Sharma331
4 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)