I want to lookup the first value in another sorted table which is greater than column 3 value, keying on column 2 on the first table.
The sorted table looks like the following,. where I want to find out the first value in column 3 which is greater than the value in the 3rd column of the first file, based on col2 in 1st file,and return the corresponding value in col2 of sorted file.
The desired output is
This can be achieved by joining pretty easily, but the issue is the sorted file is huge having 500 million records and joining takes a long time.
Can there be an awk solution which is faster?
This works
Please note that the second column in sorted file is not a serial number, it is just shown like this as an example.
Hi,
I am seeing very high kernel usage and very high load averages on my system (Although we are not loading much data to our database). Here is the output of top...does anyone know what i should be looking at?
Thanks,
Lorraine
last pid: 13144; load averages: 22.32, 19.81, 16.78 ... (4 Replies)
Write a quick shell snippet to find all of the IPV4 IP addresses
in any and all of the files under /var/lib/output/*, ignoring
whatever else may be in those files. Perform a reverse lookup on
each, and format the output neatly, like "IP=192.168.0.1,
... (0 Replies)
I have a lookup file in unix say /data/lkp.dat (First line is header and space delimited) and the content is shown below.
Another file which contains the job_name and rec_count lets say /data/data_file.dat(no header pipe delimited file).
Now i want to do a lookup on job_name and my output should... (3 Replies)
i have a Intel Quad Core Xeon X3440 (4 x 2.53GHz, 8MB Cache, Hyper Threaded) with 16gig and 1tb harddrive with a 1gb port and my apache is causing my cpu to go up to 100% on all four cores heres my http.config
<IfModule prefork.c>
StartServers 10
MinSpareServers 10
MaxSpareServers 15... (4 Replies)
Hello everybody;
I am working on a script about ip location lookup.
I 've a decimal list
dec_list:
16777216,17367039,AU,AUS,AUSTRALIA
17367040,17432575,MY,MYS,MALAYSIA
17432576,17498111,AU,AUS,AUSTRALIA
17498112,17563647,KR,KOR,REPUBLIC OF KOREA
17563648,17825791,CN,CHN,CHINA... (2 Replies)
Hi ,
I am trying to :wall: my head while scripting ..I am really new to this stuff , never did it before :( .
how to find cpu's system high time and user time high in a script??
thanks , help would be appreciated !
:) (9 Replies)
Hi,
need your help to lookup these 2 files
main.txt
RNPMS01,PMS717W_Marasi,CXP9016141/1_R7G04,EXECUTING
RNPMS01,RAP765W_BakaranBatu,CXP9014346/1_R6AG03,EXECUTING
RNPMS01,RNPMS01,CXP9014711/2_R5Z,EXECUTING
RNPMS01,TBT510W_Bandar_Utama,CXP9014346/1_R6AG03,EXECUTING... (8 Replies)
Hi All,
I want to lookup name for an id in col2 input from another file and add the name to each line.
Input 1
comp100001_c0_seq1 At1g31340 30.40 569 384 11 3 1673 313 834 7e-62 237
comp100003_c0_seq1 At1g35370_2 35.00 80 50 ... (7 Replies)
A text file has two logs of same event & both logs have to be correlated into a single line before same can be processed further
RAW
OPERATING LOG
Date Month Year Time Event
10 JAN 2014 1000 4
11 APR 2013 1230 2
12 FEB 2014 ... (7 Replies)
Discussion started by: newageBATMAN
7 Replies
LEARN ABOUT NETBSD
comm
COMM(1) BSD General Commands Manual COMM(1)NAME
comm -- select or reject lines common to two files
SYNOPSIS
comm [-123f] file1 file2
DESCRIPTION
The comm utility reads file1 and file2, which should be sorted lexically, and produces three text columns as output: lines only in file1;
lines only in file2; and lines in both files.
The filename ``-'' means the standard input.
The following options are available:
-1 Suppress printing of column 1.
-2 Suppress printing of column 2.
-3 Suppress printing of column 3.
-f Fold case in line comparisons.
Each column will have a number of tab characters prepended to it equal to the number of lower numbered columns that are being printed. For
example, if column number two is being suppressed, lines printed in column number one will not have any tabs preceding them, and lines
printed in column number three will have one.
comm assumes that the files are lexically sorted; all characters participate in line comparisons.
EXIT STATUS
comm exits 0 on success, >0 if an error occurred.
SEE ALSO cmp(1), diff(1), sort(1), uniq(1)STANDARDS
The comm utility conforms to IEEE Std 1003.2-1992 (``POSIX.2'').
BSD June 6, 1993 BSD