Shell Programming and Scripting

Hey guys
I have got a tab-separated file and I want to copy only selected records from two columns at a time satisfying specified condition, and create a new file.

My tab separated file is like this



Each column is sorted so top ranking scores are maximum scores. I want to copy only the scores>0.1 with their corresponding rownames from this file to another file and create two columns as mentioned below.

Resulting file can be

Any suggestions ?

Code:

 
awk 'BEGIN {print "ID   SCORE"} {if($2 > 0.1){print $1, $2}}' $file_name

Hi, thanks.
In my input file I have got 10 columns ( 5 pairs of IDs and scores). Is it possible to add some loop that can fetch the records from not only first two but also from other 8 columns to another file ?

Code:

nawk 'FNR>1{for(i=1;i<=NF;i+=2) if ($(i+1)>0.1) print $i,$(i+1)}' myFile

Code:

awk 'NR==1{print $1,$2}FNR==1{i+=2;next}$i>0.1{print $(i-1),$i}' file file file file file

Code:

ID score
1_11 0.80
A_34 0.34
2_23 0.74
A_45 0.49
A_36 0.34
2.36 0.78
2_34 0.75
W_9 0.34
W_898 0.13

Many Thanks.
Unfortunate I get an error message - nawk not found. I have mac osx. I don´t have nawk/gawk available.

Is it possible to use awk instead of nawk ?
I also want to use tab separator in output file.

---------- Post updated at 10:22 AM ---------- Previous update was at 10:19 AM ----------

Hi Scrutinizer,
I have only one input file with multiple pairs of columns. What change would be required in the command you suggested ?

Hi, you just need to specify the same input file 5 times on the command line...