nixCraft
help me in editing this columns
This is a discussion on help me in editing this columns within the Shell scripting forums, part of the Development/Scripting category; Hi to all. I am new to linux. I am using redhat linux. data is like this in a text ...
|
|||||||
| Register | FAQ | Members List | Calendar | Forgotten your password? | Mark Forums Read |
12-07-2006, 10:42 AM
|
|||
|
|||
help me in editing this columns
Hi to all.
I am new to linux. I am using redhat linux. data is like this in a text file 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 [quote] i have to convert this two column type into firt column,second column, and thirdcolumn like which i have shown below... using sed or awk.. SHEET MET ASP PHE SER THR ALA LEU LEU MET SER ALA GLN [quote] Second column [code] SSBOND CYS CYS CYS CYS CYS CYS CYS CYS [quote] Third column [code] CISPEP THR ALA ALA THR ALA THR ALA THR [code] Thanks for your reply. Help me in this.. Do you know some good tutorials for sed and awk for editing text files.. with kind regards ramesh 
|
| Sponsored Links | ||
|
|
|
12-12-2006, 03:29 PM
|
||||
|
||||
|
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 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 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
|
 |
| Bookmarks |
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) |
|
| Thread Tools | |
| Display Modes | |
Linear Mode
|
|
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Howto Ubuntu Linux editing admin or root configuration files | tom | Getting started tutorials | 3 | 03-25-2008 12:50 AM |
| Create output in columns | rakeshrhn | Shell scripting | 5 | 12-07-2007 07:27 PM |
| Mysql how to specify select columns | raj | Databases servers | 2 | 12-19-2006 02:23 AM |
| Editing binary without corrupting it? | karabaja | Shell scripting | 2 | 10-03-2006 08:34 AM |
| Calculations across different lines & columns of a file | Guest | Shell scripting | 2 | 09-16-2005 05:18 AM |
All times are GMT +5.5. The time now is 05:31 PM.
