Hi,

I have two files, mentioning below
1st file:
919030055000,1
919030055000,3
919030055000,7
919030155000,1
919030155000,3
919031055000,1
919031055000,8
919031155000,1
919031155000,8
919036055000,3
919036055000,7
919036155000,3
919036155000,7
919040055000,1
919040055005,7
919045123243,13

2nd file:
919030,1
919031,8
919036,3
919040,7
919045,13

I need to compare 2nd field of each entry in 1st file with the 2nd field of 2nd file with corresponding entry.
Kindly suggest me any command or something else in Unix.

Result required : COUNT for both fields matchs = 5

Thanks for support.

can u post the o/p required ?..

Result required : COUNT for both fields matchs = 5

I have to count the matches field from both files:
matching fields from 1st file are:

919030055000,1
919031055000,8
919036055000,3
919040055000,7
919045123243,13

corresponded to 2nd file entry.

Hence count is 5.

Thanks for your kind attention.

Still not proper ..

919030055000,1
919031055000,8
919036055000,3
919040055000,7
919045123243,13

corresponded to 2nd file entry.

2nd file:
919030,1
919031,8
919036,3
919040,7
919045,13

         919030155000,1
         919031155000,8
         ...........
         .......

I have to count the matches field from both files:
matching fields from 1st file are:

919030055000,1
919030055000,3
919030055000,7
919030155000,1
919030155000,3
919031055000,1
919031055000,8
919031155000,1
919031155000,8
919036055000,3
919036055000,7
919036155000,3
919036155000,7
919040055000,1
919040055005,7
919045123243,13

corresponded to 2nd file entry.
919030,1
919031,8
919036,3
919040,7
919045,13

result is
919030055000,1
919031055000,8
919036055000,3
919040055000,7
919045123243,13
Count=5

i did work :
cat Second_FILE.txt | while read myLine
do
myWord1=`echo $myLine|awk -F "," '{print $1}'`
myWord2=`echo $myLine|awk -F "," '{print $2}'`

myWord4=`grep ^$myWord1 FIRST.txt | awk -F "," '{print $2}'`
################### Comparing 2nd field of 1st file with 2nd file ##############
if [ $myWord2 -eq $myWord4 ];then
hplmn=`expr $hplmn + 1`
echo $hplmn >> NUMBER.txt
fi

echo "COUNT for both fields matchs =" $hplmn
done
But it is not work properly;

Try this:

awk -F, '
NR==FNR{a[$1$2];next}
substr($1,1,6)$2 in a{print;s++;delete a[substr($1,1,6)$2]}
END{print "Count="s}
' file2 file1

Output generated by given code:

awk -F, '
> NR==FNR{a[$1$2];next}
> substr($1,1,6)$2 in a{print;s++;delete a[substr($1,1,6)$2]}
> END{print "Count="s}
> ' DATAFILE.txt CONFIG.txt
Count=