UNIX for Dummies Questions & Answers

Hi,

I have a wide and long dataset which looks as follows:

Code:

0 3 4 2 3 0 2 2 ...
3 2 4 0 2 2 2 3 ...
0 3 4 2 0 4 4 4 ...
3 0 4 2 2 4 2 4 ...
....

I would like to obtain the minimum of each column (ignoring zero values) so the output would look like:

Code:

3 2 4 2 2 2 2 2

I have the following code but it doesn't allow for ignoring the zero values:

Code:

awk '{for(i=0;++i<=NF; ) A[i]=(!(i in A))?$i: ($i<A[i])?$i:A[i]}END{i=1;do {printf A[i] FS} while (++i in A);print z}' indata

Therefore the results are:

Code:

0 0 4 0 0 0 2 2

The only time I would want a zero for the minimum would be if all the values in the column are a zero.

Many thanks in advance,
Kathryn

Moderator's Comments:

Please use code tags <- click the link!

It's probably your smilies!

Use code tags.

Insert "if($i>0)" before "A[i]=...". May need to change "printf A[i] FS" to "printf A[i]+0 FS"

Thanks very much. That works perfectly!