Shell Programming and Scripting

Hello all,

I have a problem with a skript of mine:

My input has the following format

Code:

1,33296 transcript_id"ENSRNOT00000018629"  0 1,33296 0
0 transcript_id"ENSRNOT00000029014"  0
0,907392 transcript_id"ENSRNOT00000016905"  0,907392
0 transcript_id"ENSRNOT00000053370"  0
0 transcript_id"ENSRNOT00000038480"  0 0 0 0 0 0 0 0 0
0 transcript_id"ENSRNOT00000019722"  0 0 0
11,4615 transcript_id"ENSRNOT00000002187"  1,40701 1,13791 1,22749 1,22412 1,57927 1,29104 1,02167 1,41525 1,15769

The first field is the sum of all fields after the $2. Now I want to add a field upfront that is the sum ($1) divided by the number of all fields that are not zero.

This is what I came up with until now:

Code:

awk 'BEGIN {cnt=0; for(i=3;i<=NF;i++) {if ($i != 0) {cnt++}}; if (cnt != 0) {print $1/cnt, $0} else {print 0,$0} }'

However, this does not work. I ran into the problem dividing by zero, so I included a second if statement. I don't know if this is allowed, though.

Best,
Seb

---------- Post updated at 09:18 AM ---------- Previous update was at 09:13 AM ----------

Just found the solution: Leave the "BEGIN" out and it works ;D

still a beginner!