Shell Programming and Scripting

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 ?..

Code:

Result required : COUNT for both fields matchs = 5

which matches ???...

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 ..

Code:

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

corresponded to 2nd file entry.

Where as your second file contains :

Code:

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

where the match is happening ?...

Y not

Code:

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

From the First file ?...

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:

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}
' file2 file1

Use nawk or /usr/xpg4/bin/awk on Solaris.

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=