UNIX for Dummies Questions & Answers

Hi,

I have a space delimited text file that looks like the following:

Code:

Aa 100 200
Bb 300 100
Cc X 500
Dd 600 X

Basically, I want to take the average of columns 2 and 3 and print it in column 4. However if there is an X in either column 2 or 3, I want to print the non-X value. Therefore the output will look like this:

Code:

Aa 100 200 150
Bb 300 100 200
Cc X 500 500
Dd 600 X 600

How do I go about doing this? Thanks!

Code:

awk '/X/ { for(N=2; N<=NF; N++) if($N != "X") break } $4=$N; print; next } { $4=($3+$2)/2 } 1' inputfile

I get the following error msg when I try the code:

awk: /X/ { for(N=2; N<=NF; N++) if($N != "X") break } $4=$N; print; next } { $4=($3+$2)/2 } 1
awk: ^ syntax error
awk: each rule must have a pattern or an action part
awk: /X/ { for(N=2; N<=NF; N++) if($N != "X") break } $4=$N; print; next } { $4=($3+$2)/2 } 1
awk:

There is an extra "}" exists, try with above.

How would I go about altering the code if there are more than 2 files?

Depends what you want it to do with those files.

Sorry, I meant more than two columns so that the code would have to be altered to take the average of more than two columns ignoring the X's.