|
|
|
|
|||||||
| Forums | Portal | Register | Forum Rules | FAQ | Contribute | Members List | Arcade | Search | Today's Posts | Mark Forums Read |
| 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 |
 |
|
|
Submit Tools | LinkBack | Thread Tools | Display Modes |
07-20-2006
|
|||
|
|||
|
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_| ----------------- 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| -------------------- 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| -------------- 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_| ------------ 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
Last edited by reborg; 07-20-2006 at 04:46 AM. Reason: add code tags 
|
|||
| Google The UNIX and Linux Forums |
| Forum Sponsor | ||
|
|
Linear Mode
