The UNIX and Linux Forums  

Go Back   The UNIX and Linux Forums > Top Forums > Shell Programming and Scripting
Google UNIX.COM


Shell Programming and Scripting Post questions about KSH, CSH, SH, BASH, PERL, PHP, SED, AWK and OTHER shell scripts here.

More UNIX and Linux Forum Topics You Might Find Helpful
Thread Thread Starter Forum Replies Last Post
Help needed please. jerryboy78 UNIX for Dummies Questions & Answers 3 03-16-2008 10:06 AM
help needed nnayagam Shell Programming and Scripting 2 03-07-2008 02:34 AM
Little help needed. Netghost AIX 5 08-10-2006 11:29 AM
Help needed dsravan Shell Programming and Scripting 2 07-20-2006 06:37 AM
Sed help needed stevefox Shell Programming and Scripting 5 12-04-2005 09:44 PM

Reply
 
Submit Tools LinkBack Thread Tools Display Modes
  #1 (permalink)  
Old 07-20-2006
Registered User
 

Join Date: Oct 2005
Posts: 67
Stumble this Post!
awk help needed.

Dear All,
I want to compare column 3 and column 4 of files(File1 and File2) and want to get the matched records in one file and rejected records in another file.I have tried an awk script,but as Iam not good in it,I cant able to continue.Can anyone help me in this one.

File 1
-----------------------
Code:
Serial3/0/0:1|SA_WARNERS DE MEXICO Tultitlan|192.168.152.125|Link_|
Serial3/0/1:1|SA_GIM GPO IND MEXICANO SITIO MEX||Link_|
Serial3/0/1:1.1|SA_GIM GPO IND MEXICANO SITIO MEX|192.168.152.13|Link_20-60-0-768|
Serial3/0/1:2|INTERLINGUA_ECATEPEC||Link_|
Serial3/0/1:2.1|INTERLINGUA_ECATEPEC|192.168.157.45|Link_41-40-0-CI-256|
Serial3/0/1:3|SA_BURGER KING SITIO CUAJIMALPA||Link_|
Serial3/0/1:3.1|SA_BURGER KING SITIO CUAJIMALPA|192.168.157.49|Link_55-31-0-64-SR|
Serial3/0/1:4|SA_BURGER KING SITIO AGUILAS||Link_|
Serial3/0/1:4.1|SA_BURGER KING SITIO AGUILAS|192.168.158.21|Link_55-31-0-64|
Serial3/0/1:5|SA_BURGER KING SITIO MADERO||Link_|
File 2
-----------------
Code:
KIDDE DE MEXICO SITIO ALMACEN MEX 100710|Serial3/1/2:2.1|192.168.146.33|Link_P2_128|
INSUMOS CREATIVOS 104014|Serial10/0/7:6.1|172.16.3.25|Link_P2_64|
INTERLINGUA_ECATEPEC 102421|Serial3/0/1:2.1|192.168.157.45|Link_41-40-0-CI-256|
L.A.AZTECA_DF PLAZA INN 103170|Serial10/0/4:4.1|192.168.149.25|Link_15-80-0-512|
BURGER KING MEXICANA sitio EDUARDO MOLINA 102092|Serial3/1/5:9.1|192.168.157.137|Link_55-31-0-64|
BURGER KING SITIO CUAJIMALPA 102332|Serial3/0/1:3.1|192.168.157.49|Link_55-31-0-64|
BURGER KING SITIO AGUILAS 102331|Serial3/0/1:4.1|192.168.158.21|Link_55-31-0-64|
BURGER KING SITIO ROMA 102158|Serial3/1/5:13.1|192.168.157.21|Link_55-31-0-64|
BURGER MARIO COLIN 102196|Serial3/1/5:11.1|192.168.157.209|Link_55-31-0-64|
BURGER KING SITIO|Serial3/1/2:4.1|192.168.154.153|Link_55-31-0-64|
BURGER KING|Serial3/1/5:4.1|192.168.168.29|Link_55-31-0-64|
File 2 Success File
--------------------
Code:
INTERLINGUA_ECATEPEC 102421|Serial3/0/1:2.1|192.168.157.45|Link_41-40-0-CI-256|
BURGER KING SITIO AGUILAS 102331|Serial3/0/1:4.1|192.168.158.21|Link_55-31-0-64|
File 1 Rejected File
--------------
Code:
Serial3/0/0:1|SA_WARNERS DE MEXICO Tultitlan|192.168.152.125|Link_|
Serial3/0/1:1|SA_GIM GPO IND MEXICANO SITIO MEX||Link_|
Serial3/0/1:1.1|SA_GIM GPO IND MEXICANO SITIO MEX|192.168.152.13|Link_20-60-0-768|
Serial3/0/1:2|INTERLINGUA_ECATEPEC||Link_|
Serial3/0/1:3|SA_BURGER KING SITIO CUAJIMALPA||Link_|
Serial3/0/1:3.1|SA_BURGER KING SITIO CUAJIMALPA|192.168.157.49|Link_55-31-0-64-SR|
Serial3/0/1:4|SA_BURGER KING SITIO AGUILAS||Link_|
Serial3/0/1:5|SA_BURGER KING SITIO MADERO||Link_|
Awk Script:
------------
Code:
awk -F"|" '
function checkStr(x,y){return x=y ? x : y }
NR==FNR{++c;a[NR]=$3;b[NR]=$4;next}
{ for(i=1;i<=c;++i)
    if(checkStr($3,a[i]) && checkStr($4,b[i])){
    print $3 " " a[i];print $4 " " b[i];next
}}
' File1 File2
Thanks in Advance

Last edited by reborg; 07-20-2006 at 04:46 AM. Reason: add code tags
Reply With Quote
Google The UNIX and Linux Forums
Forum Sponsor
Reply

Thread Tools
Display Modes




All times are GMT -7. The time now is 08:11 PM.


Powered by: vBulletin, Copyright ©2000 - 2006, Jelsoft Enterprises Limited.
The UNIX and Linux Forums Content Copyright ©1993-2008 The CEP Blog All Rights Reserved -Ad Management by RedTyger Visit The Global Fact Book

Content Relevant URLs by vBSEO 3.2.0