[SOLVED] Adding a column with awk

Tauro · 07-27-2011, 06:23 AM

Input file

Code:

Ribosomal_L14
PF00238.13
C9JD32_HUMAN/23-91
B9ZVP7_HUMAN/19-80
Q9BTQ7_HUMAN/13-134


Ribosomal_L16
PF00252.12
B8A6G2_HUMAN/1-103
C9J7T6_HUMAN/1-116
Q5HY50_HUMAN/20-183
A6QRI9_HUMAN/5-136
D3DWW6_HUMAN/5-167

Ribosomal_L17
PF01196.13
D3DQU3_HUMAN/28-126

Desired output:

Code:

Ribosomal_L14 PF00238.13 C9JD32_HUMAN/23-91
Ribosomal_L14 PF00238.13 B9ZVP7_HUMAN/19-80
Ribosomal_L14 PF00238.13 Q9BTQ7_HUMAN/13-134

Ribosomal_L16 PF00252.12 B8A6G2_HUMAN/1-103
Ribosomal_L16 PF00252.12 C9J7T6_HUMAN/1-116
Ribosomal_L16 PF00252.12 Q5HY50_HUMAN/20-183
Ribosomal_L16 PF00252.12 A6QRI9_HUMAN/5-136
Ribosomal_L16 PF00252.12 D3DWW6_HUMAN/5-167

PLz help me out with awk.!!

radoulov · 07-27-2011, 07:17 AM

Code:

awk '{
  for ( i = 2; ++i <= NF; )
    print $1, $2, $i
  print x	
  }' RS= infile

Tauro · 07-27-2011, 07:41 AM

Thanks for the code. What i get with this is:

Code:

1-cysPrx_C PF10417.3 PRDX3_HUMAN
1-cysPrx_C PF10417.3 218-253
1-cysPrx_C PF10417.3 D3DRC9_HUMAN
1-cysPrx_C PF10417.3 218-253
1-cysPrx_C PF10417.3 Q53HC2_HUMAN
1-cysPrx_C PF10417.3 218-253
1-cysPrx_C PF10417.3 Q14579_HUMAN
1-cysPrx_C PF10417.3 1-27

..
..

Well I sorted out this problem of printing every field with $1 and $2. Putting a field separator solved it.
Thanks again for the help