Login or Register to Ask a Question and Join Our Community


UNIX for Dummies Questions & Answers

Editing files

 
Thread Tools Search this Thread
Top Forums UNIX for Dummies Questions & Answers Editing files
# 1  
Old 10-21-2014
Editing files
This is a smallpart of my input file.I want to change the ID values of entries having CMW as an entry.

Code:
Cont_1.266      .       CMW     2958    3269    .       -       0       PARENT=t:UM06506T0;ID=UM06506P0;rank=6 
Cont_1.266      .       CMW     3394    3505    .       -       0       PARENT=t:UM06506T0;ID=UM06506P0;rank=5 
Cont_1.266      .       teef    3394    3505    .       -       .       NAME=UM06506.5;PARENT=t:UM06506T0;constitutive=1;ensembl_end_phase=0;ensembl_phase=2;rank=5 
Cont_1.266      .       CMW     3532    3713    .       -       0       PARENT=t:UM06506T0;ID=UM06506P0;rank=4 
Cont_1.266      .       teef    3532    3713    .       -       .       NAME=UM06506.4;PARENT=t:UM06506T0;constitutive=1;ensembl_end_phase=2;ensembl_phase=0;rank=4 
Cont_1.266      .       CMW     3743    4624    .       -       0       PARENT=t:UM06506T0;ID=UM06506P0;rank=3 
Cont_1.266      .       teef    3743    4624    .       -       .       NAME=UM06506.3;PARENT=t:UM06506T0;constitutive=1;ensembl_end_phase=0;ensembl_phase=0;rank=3 
Cont_1.266      .       CMW     4659    5123    .       -       0       PARENT=t:UM06506T0;ID=UM06506P0;rank=2 
Cont_1.266      .       teef    4659    5123    .       -       .       NAME=UM06506.2;PARENT=t:UM06506T0;constitutive=1;ensembl_end_phase=0;ensembl_phase=0;rank=2 
Cont_1.266      .       CMW     5151    6146    .       -       0       PARENT=t:UM06506T0;ID=UM06506P0;rank=1



So for this eg I want to change ID value to include the rank value
Here it is 6.

Input
Code:
Cont_1.266      .       CMW     2958    3269    .       -       0       PARENT=t:UM06506T0;ID=UM06506P0;rank=6

Output
Code:
Cont_1.266      .       CMW     2958    3269    .       -       0       PARENT=t:UM06506T0;ID=UM06506P0.6;rank=6

So I want all the ID values of CMW entries to include the rank values.

Is it possible to do with awk/sed?
I tried manually but its too many entries.
# 2  
Old 10-21-2014
Maybe one of:

Code:
perl -wlpe '/CMW/ and s/(ID=\w+)(;rank=)(\d)/$1\.$3$2$3/' filename

Code:
perl -wlpe '/CMW/ and ($r) = $_=~ /(\d)\s?$/ and s/(ID=\w+)/$1\.$r/' filename

Last edited by Aia; 10-21-2014 at 10:56 PM..
# 3  
Old 10-21-2014
Try
Code:
sed '/CMW/ s/\(ID.[^;]*\)\(;rank=\)\(.[^ ]*\)/\1.\3\2\3/' file

# 4  
Old 10-21-2014
Or try
Code:
sed '/CMW/s/;rank=\([^ ]*\)/.\1&/' file

This User Gave Thanks to Scrutinizer For This Post:
junior-helper
 
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Bash script deleting my files, and editing files in subdirectories question

#!/bin/bash # name=$1 type=$2 number=1 for file in ./** do if then filenumber=00$number elif then filenumber=0$number fi tempname="$name""$filenumber"."$type" if (4 Replies)
Discussion started by: TheGreatGizmo
4 Replies

2. Shell Programming and Scripting

editing files.

hello, i have a problem. suppose file.txt i want to add lines over those lines in a file if it starts and ends with how and "?" respectively. i want output like output file.txt thanks (4 Replies)
Discussion started by: yashwantkumar
4 Replies

3. Programming

Editing binary files

I am working in C and need a solution for below problem: I have a binary file, which needs to be edited in such a way no data is loss. For example i have to insert 3 bytes of data at some position without changing the contents of the file. if file has data as:... (2 Replies)
Discussion started by: junaid.nehvi
2 Replies

4. Shell Programming and Scripting

Editing files to add some thing in all the files in a folder

Hi All, I have a folder that contains 100's of files and each file have a similar content like the following format: ((STBJa:200.0,((STBTz:200.0,(STSwe:200.0,(STDUw:200.0,(ST4Bu:200.0,STL2b:200.0):127.0):86.0):80.0):120.0, STAHr:200.0):134.0):200.0,STuNg:200.0);What I need is to do is add "#1"... (2 Replies)
Discussion started by: Lucky Ali
2 Replies

5. Shell Programming and Scripting

editing files

Is there any command which I can apply from the command line to find and replace a particular text say "00:00:00:00" with "00" from all the files( where ever this text exists) of the current directory? (17 Replies)
Discussion started by: cobroraj
17 Replies

6. Solaris

editing files with script

hi guys, We have to implement new local (/etc/default/login) USER security policy on almost 50 stations. so editing /etc/default/login and /etc/default/passwd will be way too long work. Can we do the same using some script, I mean editing the above files and putting variables as RETRIES=3, ... (5 Replies)
Discussion started by: Asteroid
5 Replies

7. Solaris

changing IP thru editing files

I attempted to change the IP of my Solaris 9 box by changing these files: /etc/hosts /etc/hostname.dmfe0 And when I rebooted my system, the changes did not come up through the reboots. I have searched high and low and this is how you change the IP address permanently. Can anyone tell me what... (2 Replies)
Discussion started by: bluridge
2 Replies

8. OS X (Apple)

the best way of editing .plist files

:( what is the best way of editing the various .plist files without adding third party files? Or is the easiest way is to add third party applications, which ones? please kept in mind that i am not a programmer. mike (1 Reply)
Discussion started by: mehow
1 Replies

9. UNIX for Dummies Questions & Answers

Editing files

hi i would like to know whether i can delete a part of a file in C for eg. if my file contained 1234567890 and i want to delete 456 so that it becomes 1237890 is there a way i can do this. well, one way i can achieve this is by creating a new file, copy whatever i want, then... (2 Replies)
Discussion started by: sameersbn
2 Replies

10. UNIX for Dummies Questions & Answers

editing unix files on NT

i currently am using a unix server and NT pc. i have downloaded a ziped file that should explode into 3 seperate unix based files, however when i unzip it using Alading Expander it displays only 1. This exploded version contains all 3 files ( you can scroll down when viewing the file and see the... (1 Reply)
Discussion started by: pixelmonkey
1 Replies
Login or Register to Ask a Question