|
|
|
google unix.com
|
|||||||
| Forums | Register | Forum Rules | Links | Albums | FAQ | Members List | Calendar | 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 and shell scripting languages 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 02:06 PM |
| help needed | nnayagam | Shell Programming and Scripting | 2 | 03-07-2008 06:34 AM |
| Little help needed. | Netghost | AIX | 5 | 08-10-2006 03:29 PM |
| Help needed | dsravan | Shell Programming and Scripting | 2 | 07-20-2006 10:37 AM |
| Sed help needed | stevefox | Shell Programming and Scripting | 5 | 12-05-2005 01:44 AM |
Powered by 
|
|
|
LinkBack | Thread Tools | Search this Thread | Rate Thread | 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 08:46 AM.. Reason: add code tags |
| Bookmarks |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
Threaded Mode
