Search Results

awk '
{VT = $NF # Extract last field into Value Temp variable
sub (FS "*" VT "$", _) ...

Making the assumption you want to compare line by line, and ignoring the special case of equal values, I come up with
awk '
{VT = $NF
sub (FS "*" VT "$", _)
...

awk -F, '{gsub("[^-+0-9.,]","",$(NF-2));s+=$(NF-2)}END{print s}' myFile

Single grep approach:
sed 's/^/^/' filea | grep -of- fileb | sort | uniq -c
1 39
2 44You can drop the sort if fileb is already sorted.

Supress showing the zero matches:
while read cc
do
c=$(grep -c "^$cc" fileb) &&
echo "$cc - $c times"
done <filea
...
END {for (i in a) if (a[i]) printf("%d - %d times\n", i, a[i])}
'...

or:

awk 'FNR==NR {a[$1];next} {for(i in a) if ($0 ~ ("^"i)) a[i]++}END {for (i in a) printf("%d - %d times\n", i, a[i])}' fileA fileB

The lazy way if you just have to run it once.

while read cc
do
echo $cc $(grep -c "^$cc" fileb)
done <filea


If you have to run this frequently, or the number of records in filea is...