Shell Scripting: Trying to combine upload and download totals from txt file by ip add

[zanyspydude]

I have two files, uploads.txt and downloads.txt. I would like to combine the columns of these files based on the ip address. How can I best do this?

Uploads.txt

192.168.0.147 1565369
192.168.0.13 1664855
192.168.0.6 1332868

Downloads.txt

192.168.0.147 9838820
192.168.0.18 12051718
192.168.0.6 7633159

I want something that looks like

192.168.0.147 9999999999
192.168.0.18 9999999999
192.168.0.13 9999999999
192.168.0.6 9999999999

where 999999 is the sum of the downloads and uploads.

Thank you!

[barbus]

paste /tmp/u.txt /tmp/d.txt | while read ip u ip d ; do sum=$(($d+$u)); echo $ip $sum; done

[Kloschüssel]

This won't work if the lines of each file do not correspond to the same IP. I.e. given the example, line 3 (ip 0.6 and 0.13) will be summed up but shouldn't.

#!/bin/sh

while read dline
do
  # sto
  ip=`sed 's/^(.*) [0-9]*$/\^1/g < $dline`
  total=`sed 's/^.*([0-9]*)$/\^1/g < $dline`
  while read uline
    do
      # add
      part=`sed 's/^.*([0-9]*)$/\^1/g < $uline`
      total=`expr $total + $part`
    done < (grep $d u.txt)
   # out
   echo $ip $total
done < d.txt

All without warranty. Haven't tested it.

[barbus]

I assumed all lines are corresponding in both files and in the example it was a mistake

[Franklin52]

This question is also answered here:

Trying to combine upload and download totals from txt file by ip address - The UNIX and Linux Forums

Regards

[barbus]

Yes, nice solution.

[Kloschüssel]

How I hate double posts. *pf* Why noone uses the search function or web search engines?

[zanyspydude]

How I hate double posts. *pf* Why noone uses the search function or web search engines?

If you will look closely, you will notice that I double posted on both sites in-case the member sets do not overlap.

The best solution is:

awk '{a[$1]+=$2}END{for(i in a)print i, a[i]}' uploads.txt downloads.txt

Thank you all for your help!