Match on columns and replace other columns

Shell Programming and Scripting
1

Hi Friends,

I have the following input file

cat input
chr1 100 200 0.1 0.2 na 1 na nd
chr1 105 200 0.1 0.2 1 1 na 98
chr1 110 290 nf 1 na nd na 1
chr2 130 150 12 3 na 1 na 1
chr3 450 600 nf nf na 10 na nd
chr4 300 330 1 1 10 11 23 34

My requirement is

  1. If $6 is na make $7 nd and $4 nf and $5 nf.
  2. If $8 is na make $9 nd and $4 nf and $5 nf.

This is my output file

cat output
chr1 100 200 nf nf na nd na nd
chr1 105 200 nf nf na nd na nd
chr1 110 290 nf nf na nd na nd
chr2 130 150 nf nf na nd na nd
chr3 450 600 nf nf na nd na nd
chr4 300 330 1 1 10 11 23 34

Thanks in advance

2 
awk ' {
 if($6=="na") {
  $7="nd";
  $4="nf";
  $5="nf";
 }
 if($8=="na") {
  $9="nd";
  $4="nf";
  $5="nf";
 }
}1' input
1 Like
3

Damn, I have to learn thinking simple. Thanks my friend.