CODEWITHSUNDEEP
unixawk
Prima Winangun
Prima Winangun

Reputation: 33

AWK command for sum 2 files

i am new at awk and i need awk command to summing 2 files if found the same column

file 1

a | 16:00 | 24
b | 16:00 | 12
c | 16:00 | 32

file 2

b | 16:00 | 10
c | 16:00 | 5
d | 16:00 | 14

and the output should be

a | 16:00 | 24
b | 16:00 | 22
c | 16:00 | 37
d | 16:00 | 14

i have read some of the question here and still found the correct way to do it, i already tried with this command

awk 'BEGIN { FS = "," } ; FNR=NR{a[$1]=$2 FS $3;next}{print $0,a[$1]}'

please help me, thank you

Upvotes: 1

Views: 89

Answers (3)

CS Pei
CS Pei

Reputation: 11047

This script also uses sort but it will work,

awk -F'|'  ' { f[$1] += $3 ; g[$1] = $2 } END { for (a in f) { print a , "|",  g[a] , "|",  f[a] } } '   a.txt b.txt | sort

The results are

    a  |  16:00  | 24
    b  |  16:00  | 22
    c  |  16:00  | 37
    d  |  16:00  | 14

Upvotes: 2

fedorqui
fedorqui

Reputation: 289525

Just store all the data in two arrays a[] and b[] and then print them back:

awk 'BEGIN{FS=OFS="|"}
     {a[$1]+=$3; b[$1]=$2}
     END{for (i in a) print i,b[i],a[i]}' f1 f2

Test

$ awk 'BEGIN{FS=OFS="|"} {a[$1]+=$3; b[$1]=$2} END{for (i in a) print i,b[i],a[i]}' f1 f2
b | 16:00 |22
c | 16:00 |37
d | 16:00 |14
a | 16:00 |24

Upvotes: 0

NeronLeVelu
NeronLeVelu

Reputation: 10039

without |sort

awk -F'|' '{O[$1FS$2]+=$3}END{asorti(O,T,"@ind_str_asc");for(t in T)print T[t] FS O[T[t]]}' file[1,2]

Upvotes: 0

Related Questions