Shell Programming and Scripting

Hi all

I have two file a.txt and b.txt and i want to compare their first coloum and print the o/p to the third file c.txt
comparing should be in such a way that if matching first coloum is not found in any of the file then it should print No row
like here AAA is present in both file so o/p file have all coloums value but BBB is not in 2n file so in o/p file 4th and the
coloum have No row entry
I am using join for matching but it prints only coloum which is in both the file
so pls help me in this
a.txt

AAA,23,34
BBB,45,67
CCC,21,33
DDD,56,78

b.txt
CCC,88,91
AAA,26,78
EEE,61,11

matching should be based on first coloum of both the file
1st coloum ,2n coloum of fisrt file,3 coloum of fist file,2n coloum of second file,3 coloum of 2n file
and if no matching coloum is found then it should be "No row"


AAA , 23 , 34 ,26 ,78
BBB , 45 , 67 ,NO row ,No row
CCC , 21 , 33 ,88 ,91
EEE , NO row , NO row ,61 ,11
DDD , 56 , 78 ,No row ,No row

pls provide me solution as it is very urgent for me

pls provide me solution as it is very urgent for me

Please don't bump up posts.

nawk -F, -f aa.awk a.txt b.txt

aa.awk:

Code:

FNR==NR { a[$1]=$2 FS $3; next}
$1 in a { print a[$1] FS $2 FS $3; delete a[$1];next }
{ print "No row" FS "No row" FS $2 FS $3; delete a[$1] }
END {
  for (i in a)
     print a[i] FS "No row" FS "No row"
}

Hi
I checked solution provided u by but it is not working it is giving me following op
No row,No row,88,91
No row,No row,26,78
No row,No row,61,11
56,78,No row,No row
23,34,No row,No row
21,33,No row,No row
45,67,No row,No row

But i want to have o/p
AAA , 23 , 34 ,26 ,78
BBB , 45 , 67 ,NO row ,No row
CCC , 21 , 33 ,88 ,91
EEE , NO row , NO row ,61 ,11
DDD , 56 , 78 ,No row ,No row


for above two files.

Try this..

Code:

awk 'BEGIN{FS=OFS=",";n="No Row"
while((getline < "a.txt")>0)a[$1]=$2","$3
while((getline < "b.txt")>0)b[$1]=$2","$3
for(i in a){
if (i in b)print i,a[i],b[i]
else print i,a[i],n,n
}
for ( j in b)
{
if (j in a)print j,a[j],b[j]
else print j,n,n,b[j]
}
}' | sort -u

cheers,
Devaraj Takhellambam

slight modification:

Code:

FNR==NR { a[$1]=$2 FS $3; next}
$1 in a { print $1 FS a[$1] FS $2 FS $3; delete a[$1];next }
{ print $1 FS "No row" FS "No row" FS $2 FS $3; delete a[$1] }
END {
  for (i in a)
     print i FS a[i] FS "No row" FS "No row"
}

Thanks a lot its working fine