Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Compare files & extract column awk
Top Forums Shell Programming and Scripting Compare files & extract column awk Post 302781973 by vaibhavvsk on Monday 18th of March 2013 06:59:33 AM
Old 03-18-2013
Compare files & extract column awk
I have two tab delimited files as given below:
Code:
File_1:
PV16    E1    865    2814    1950
PV16    E2    2756    3853    1098
PV16    E4    3333    3620    288
PV16    E5    3850    4101    252
PV16    E6    83    559    477
PV16    E7    562    858    297
PV16    L2    4237    5658    1422
PV16    L1    5639    7156    1518

These two files are of unequal line counts.
Code:
File_2 :
1099    PV16    766    837    
1099    PV16    904    975    
1099    PV16    1022    1118    
1099    PV17    1198    1269    
1099    PV16    1438    1531    
1099    PV16    1572    1643    
1099    PV16    1952    2023    
1099    PV16    2070    2211    
1099    PV16    2322    2393    
1099    PV16    2432    2503    
1099    PV16    2545    2616    
1099    PV16    2808    2884    
1099    PV16    3050    3121    
1099    PV16    3507    3693    
1099    PV16    3696    3767    
1099    PV16    4036    4107    
1099    PV19    4246    4317    
1099    PV20    4383    4454    
1099    PV18    4673    4797    
1099    PV16    4811    4882

Logic to compare & add the extra column as :
HTML Code:
if (file_1.col1==file_2.col2 && file_2.col3>=file_1.col3 && file_2.col4<=file_1.col4) 
then 
print "file_2.col1,"\t",1 file_2.col2,"\t",file_2.col3,"\t",file_2.col4,"\t",file_1.col2,"\n";
else
print "file_2.col,"\t",1 file_2.col2,"\t",file_2.col3,"\t",file_2.col4,"\t","Null","\n";
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

awk compare column between 2 files

Hi, I would like to compare file1 and file2 file1 1 2 3 file2 1 a 2 b 3 c 4 d The result should only print out "d" in file 2. Thanks (3 Replies)
Discussion started by: phamp008
3 Replies

2. Shell Programming and Scripting

How to extract a column from two different files in AWK?

Hi guys, I need help in extracting one column of numbers from two different files and display it in a output file. In specific, I want to extrac the column no.2 ($2) from each file, file1.txt, file2.txt. Then place both extracted columns in a one file, out.txt. the line command I use to... (7 Replies)
Discussion started by: solracq
7 Replies

3. UNIX for Advanced & Expert Users

Compare two files using awk or sed, add values in a column if their previous fields are same

Hi All, I have two files file1: abc,def,ghi,5,jkl,mno pqr,stu,ghi,10,vwx,xyz cba,ust,ihg,4,cdu,oqw file2: ravi,def,kishore ramu,ust,krishna joseph,stu,mike I need two output files as follows In my above example, each row in file1 has 6 fields and each row in file2 has 3... (1 Reply)
Discussion started by: yerruhari
1 Replies

4. UNIX for Dummies Questions & Answers

Compare two files using awk or sed, add values in a column if their previous fields are same

Hi All, I have two files file1: abc,def,ghi,5,jkl,mno pqr,stu,ghi,10,vwx,xyz cba,ust,ihg,4,cdu,oqw file2: ravi,def,kishore ramu,ust,krishna joseph,stu,mike I need two output files as follows In my above example, each row in file1 has 6 fields and each row in file2 has 3... (1 Reply)
Discussion started by: yerruhari
1 Replies

5. Shell Programming and Scripting

Compare two files using awk or sed, add values in a column if their previous fields are same

Hi All, I have two files file1: abc,def,ghi,5,jkl,mno pqr,stu,ghi,10,vwx,xyz cba,ust,ihg,4,cdu,oqw file2: ravi,def,kishore ramu,ust,krishna joseph,stu,mike I need two output files as follows In my above example, each row in file1 has 6 fields and each row in file2 has 3... (3 Replies)
Discussion started by: yerruhari
3 Replies

6. Shell Programming and Scripting

Compare & subtract lines in files by column using awk.

I have two files with similar column pattern as given below : 2 sample lines from file1 are given below. 18 12630 . G T 49.97 . AC=2;AF=1.00;AN=2;DP=3;Dels=0.00;FS=0.000;HRun=0;HaplotypeScore=0.0000;MQ=60.00;MQ0=0;NDA=1;QD=16.66;SB=-0.01 GT:AD:DP:GQ:PL ... (2 Replies)
Discussion started by: vaibhavvsk
2 Replies

7. UNIX for Dummies Questions & Answers

awk command to compare files by column

So I have this issue. I have 4 files. the first one is the master file who has all possible combinations: file 1 - a - b - c - d - e the other three have some of the letters and a number instead of - for example file 2 34 a 5 c file 3 10 b 12 ... (3 Replies)
Discussion started by: Quijotes
3 Replies

8. Shell Programming and Scripting

Compare two files column values using awk

Judi # cat File1 judi /export/home 76 judi /usr 83 judi # judi # cat File2 judi /export/home 79 judi /usr 82 judi # if COLUMN3 of File2 is greater that COLUMN3 of File1, then print File2's lines juid /export/home 79 Code tags please (2 Replies)
Discussion started by: judi
2 Replies

9. Shell Programming and Scripting

Compare 2 files and extract the data which is present in other file - awk is not working

file2 content f1file2 content f1,1,2,3,4,5 f1,2,4,6,8,10 f10,1,2,3,4,5 f10,2,4,6,8,10 f5,1,2,3,4,5 f5,2,4,6,8,10awk 'FNR==NR{a;next}; !($1 in a)' file2 file1output f10,1,2,3,4,5 f10,2,4,6,8,10 f5,1,2,3,4,5 f5,2,4,6,8,10awk 'FNR==NR{a;next}; ($1 in a)' file2 file1output nothing... (4 Replies)
Discussion started by: gksenthilkumar
4 Replies

10. Shell Programming and Scripting

Need awk or Shell script to compare Column-1 of two different CSV files and print if column-1 matche

Example: I have files in below format file 1: zxc,133,joe@example.com cst,222,xyz@example1.com File 2 Contains: hxd hcd jws zxc cst File 1 has 50000 lines and file 2 has around 30000 lines : Expected Output has to be : hxd hcd jws (5 Replies)
Discussion started by: TestPractice
5 Replies

LEARN ABOUT SUSE

ocf_heartbeat_jboss

OCF_HEARTBEAT_JBOSS(7)						OCF resource agents					    OCF_HEARTBEAT_JBOSS(7)

NAME

       ocf_heartbeat_jboss - Manages a JBoss application server instance

SYNOPSIS

       jboss [start | stop | status | monitor | meta-data | validate-all]

DESCRIPTION

       Resource script for Jboss. It manages a Jboss instance as an HA resource.

SUPPORTED PARAMETERS

       resource_name
	   The name of the resource. Defaults to the name of the resource instance. (optional, string, default default)

       console
	   A destination of the log of jboss run and shutdown script. (optional, string, no default)

       shutdown_timeout
	   Timeout for jboss bin/shutdown.sh. We wait for this timeout to expire, then send the TERM and QUIT signals. Finally, the KILL signal is
	   used to terminate the jboss process. You should set the timeout for the stop operation to a value bigger than the sum of the timeout
	   parameters. See also kill_timeout. (optional, integer, default 5)

       kill_timeout
	   If bin/shutdown.sh doesn't stop the jboss process, then we send it TERM and QUIT signals, intermittently and once a second. After this
	   timeout expires, if the process is still live, we use the KILL signal. See also shutdown_timeout. (optional, integer, default 10)

       user
	   A user name to start a JBoss. (optional, string, default root)

       statusurl
	   URL to test in the monitor operation. (optional, string, default http://127.0.0.1:8080)

       java_home
	   Home directory of Java. Defaults to the environment variable JAVA_HOME. If it is not set, then define this parameter. (optional,
	   string, no default)

       jboss_home
	   Home directory of Jboss. (required, string, no default)

       pstring
	   With this string heartbeat matches for the right process to kill. (optional, string, default java -Dprogram.name=run.sh)

       run_opts
	   Start options to start Jboss with, defaults are from the Jboss-Doku. (optional, string, default -c default -l lpg4j)

       shutdown_opts
	   Stop options to stop Jboss with. (optional, string, default -s 127.0.0.1:1099)

SUPPORTED ACTIONS

       This resource agent supports the following actions (operations):

       start
	   Starts the resource. Suggested minimum timeout: 60s.

       stop
	   Stops the resource. Suggested minimum timeout: 120s.

       status
	   Performs a status check. Suggested minimum timeout: 30s.

       monitor
	   Performs a detailed status check. Suggested minimum timeout: 30s. Suggested interval: 10s.

       meta-data
	   Retrieves resource agent metadata (internal use only). Suggested minimum timeout: 5s.

       validate-all
	   Performs a validation of the resource configuration. Suggested minimum timeout: 5.

EXAMPLE

       The following is an example configuration for a jboss resource using the crm(8) shell:

	   primitive example_jboss ocf:heartbeat:jboss 
	     params 
	       jboss_home=string 
	     op monitor depth="0" timeout="30s" interval="10s"

SEE ALSO

       http://www.linux-ha.org/wiki/jboss_(resource_agent)

AUTHOR

       Linux-HA contributors (see the resource agent source for information about individual authors)

resource-agents 1.0.3						    07/05/2010						    OCF_HEARTBEAT_JBOSS(7)
All times are GMT -4. The time now is 11:07 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy