awk command

Shell Programming and Scripting
1

I am expecting 4th column to subracted in both the files and printed it using awk.

cat File1 
apple|fiesta|chennai|600
orange|santro|banglore|1400
kiwi|ford|mysore|600

cat File2
grape|fiesta|chennai|400
pine|santro|banglore|600
mango|ford|mysore|600

Awk command used 
awk -F'|' 'NR==FNR{c[$2$3]++;next};c[$2$3] > 0' file1 file2

Current Output:
apple|fiesta|chennai|600
orange|santro|banglore|1400
kiwi|ford|mysore|600

Expected output
apple|fiesta|chennai|200
orange|santro|banglore|800
kiwi|ford|mysore|0
2

Hello gowthamsoft,

Could you please try following and let me know if this helps you.

awk -F"|" 'FNR==NR{a[$2,$3]=$NF;next} (($2,$3) in a){print $1,$2,$3,a[$2,$3]-$NF}' SUBSEP="" File1  OFS="|" File2

Output will be as follows.

grape|fiesta|chennai|200
pine|santro|banglore|800
mango|ford|mysore|0

Thanks,
R. Singh

3 
awk -F'|' 'NR==FNR{c[$2,$3]=$4;next};length($4-=c[$2,$3])' OFS='|' file2 file1