View Single Post

  #2 (permalink)  
Old 12-12-2006, 03:29 PM
nixcraft's Avatar
nixcraft nixcraft is offline
Never say die
User
 
Join Date: Jan 2005
Location: BIOS
My distro: Ubuntu
Posts: 1,103
Rep Power: 10
nixcraft has a reputation beyond repute nixcraft has a reputation beyond repute nixcraft has a reputation beyond repute nixcraft has a reputation beyond repute nixcraft has a reputation beyond repute nixcraft has a reputation beyond repute nixcraft has a reputation beyond repute nixcraft has a reputation beyond repute nixcraft has a reputation beyond repute nixcraft has a reputation beyond repute nixcraft has a reputation beyond repute
Default

Ok, it is pretty easy. You need to use cut and paste. No need to use awk or sed at all.

data.txt - input file
Code:
SHEET ,MET
SHEET ,ASP
SHEET ,PHE
SHEET ,SER
SHEET ,THR
SHEET ,ALA
SHEET ,LEU
SHEET ,LEU
SHEET ,MET
SHEET ,SER
SHEET ,ALA
SHEET ,GLN
SSBOND,CYS
SSBOND,CYS
SSBOND,CYS
SSBOND,CYS
SSBOND,CYS
SSBOND,CYS
SSBOND,CYS
SSBOND,CYS
CISPEP,THR
CISPEP,ALA
CISPEP,ALA
CISPEP,THR
CISPEP,ALA
CISPEP,THR
CISPEP,ALA
CISPEP,THR
Script
Code:
#!/bin/bash
INPUT="data.txt"
grep "SHEET" $INPUT | cut -d, -f2 > /tmp/out.1
grep "SSBOND" $INPUT | cut -d, -f2 > /tmp/out.2
grep "CISPEP" $INPUT | cut -d, -f2 > /tmp/out.3
echo -e "SHEET\tSSBOND\tCISPEP"
paste out.1 out.2 out.3
Output:
Code:
SHEET   SSBOND  CISPEP
MET     CYS     THR
ASP     CYS     ALA
PHE     CYS     ALA
SER     CYS     THR
THR     CYS     ALA
ALA     CYS     THR
LEU     CYS     ALA
LEU     CYS     THR
MET
SER
ALA
GLN
__________________
Vivek | My personal blog
Linux Evangelist
Play hard stay cool
Reply With Quote