Shell Programming and Scripting

Hy everybody,

I have three file with the same formating. I need to parse those files in order that for each first column of the first file, sum the second columns of first,second and third files. Can someone help me ?

example :

# more file1
00:00:12,137;7,0333333
# more file2
00:00:22,672;7,15
# more file3
00:00:20,097;7,016667

the output that i nedd is :

00:00:12;21,2000003

Thanks in advace

The orignal files have 4 columns (split by ; or ,), but the output has only 3 columns. Not sure which colum do you need sum, and which column do you need keep in first column.

Give you a try, you can refer for your own request.

Code:

$ awk -F ";|," '{sum[$1]=sum[$1]+$3} END {for (i in sum) print i,sum[i]}' file*
00:00:20 7
00:00:12 7
00:00:22 7

If you only sum $3, you can run :

Code:

awk -F ";|," '{sum=sum+$3} END {print sum}' file*

Code:

awk -F ";|," '{if(!var){ var=$1;}sum1+=$3;sum2+=$4} END {print var","sum1","sum2}' file*

00:00:12,21,350015

HTH,
PL

Thank you Guys, but I forgot to mention that each file has more than one line and waht I need is for each first column (time) of the first file , sum the second column of the others files

file1
00:00:22,672;7,15
00:01:22,672;9,316667
00:02:22,679;18,5

file 2

00:00:25,672;9,15
00:01:22,672;10,316667
00:02:22,679;18,35

file 3

00:00:29,672;7,15
00:01:22,672;9,316667
00:02:22,679;18,5

output

($1 of the first file);(sum of $2 of the other files for each line)

00:00:22;(7,15+9,15+7,15)
00:01:22;(9,316667+10,316667+9,316667)
00:02:22;(18,5+18,35+18,5)

Hi all,

Any new idea about this issue ?

Tks.

nawk -f rob.awk file1 file2 file3 fileN

rob.awk:

Code:

BEGIN {
  FS=OFS=";"
}
FNR==NR { f1v[FNR]+=$2; f1n[FNR]=$1;next}
{ f1v[FNR]+=$2}
END {
  while(++i in f1v)
    printf("%s%c%.2f\n", f1n[i], OFS, f1v[i])
}

Hi:

Code:

paste -d\; f1 f2 f3 | awk -F\; '{print $1,$2+$4+$6}' OFS=\;

Regards,
Alister