Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Modify the file by script

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Modify the file by script
# 1  
Old 06-22-2012
Modify the file by script
Hi All,
I have an input file like below,

6984 1225
6989 1220
6994 1214
6999 1207
7004 1199
7009 1192
7014 1184
7019 1177
7024 1170
7029 1162
7034 1154
7039 1145
7044 1137
7049 1129
7054 1123
7059 1119
7064 1115
7069 1112
7074 1109
7079 1107
7084 1106
7089 1106
7094 1107
7099 1110
7104 1114
7109 1120
7114 1126
7119 1132
7124 1137
7129 1140
7134 1146
7139 1156
7144 1172
7149 1193
7154 1229
7159 1276
7164 1332
7169 1378
7174 1411
7179 1439
7184 1452
7189 1448
7194 1444
7199 1440

I want the ouput file to be

6984 1165(1145+20) )
delete all the 10 NR's from head part and tail part except the first and the last and replace the 2nd column value of the last and the first as given.
7039 1145
7044 1137
7049 1129
7054 1123
7059 1119
7064 1115
7069 1112
7074 1109
7079 1107
7084 1106
7089 1106
7094 1107
7099 1110
7104 1114
7109 1120
7114 1126
7119 1132
7124 1137
7129 1140
7134 1146
7139 1156
7144 1172
delete all the 10 NR's from head part and tail part except the first and the last and replace the 2nd column value of the last and the first as given.
7199 1192(ie 1172+20)

It shud be very simple to you xperts but I can not make it.
Thanks a lot.
Please help
Arnab
# 2  
Old 06-22-2012
Sorry, but I don't understand the request. You give us the input & desired output but what logic should be applied to the input? Maybe I'm being stupid, but what is an NR other than an awk option? I can easily add a few numbers but your request doesn't give me anything to really go on. Sorry.

Do you mean:-
  1. The first column from the first line : The second column from the 12th line plus ten
  2. Display next 22 lines
  3. The first column from the 12th line : The second column from the 33rd line plus ten

One is confused and wonders.Smilie
# 3  
Old 06-22-2012
Quote:
Originally Posted by rbatte1
One is confused and wonders.Smilie
Exactly as I felt when I read the post Smilie
# 4  
Old 06-22-2012
one way,

Code:
awk -v n=`wc -l < file` '
 NR==1 {r1=$1} 
 NR==12 {s1=$2+20} 
 NR==n {r2=$1} 
 NR==n-11 {s2=$2+20} 
 NR >11 && NR <= n-11 {a[NR] = $0} 

END {print r1 FS s1; for (i=12;i<=n-11;i++){print a[i]};print r2 FS s2} ' file

Output:

Code:
6984 1165
7039 1145
7044 1137
7049 1129
7054 1123
7059 1119
7064 1115
7069 1112
7074 1109
7079 1107
7084 1106
7089 1106
7094 1107
7099 1110
7104 1114
7109 1120
7114 1126
7119 1132
7124 1137
7129 1140
7134 1146
7139 1156
7144 1172
7199 1192


I will try to post more efficient solution later.
I think this could be done all inside awk
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Perl script to modify csv file

Hi Friends, I want to convert a csv file into a ordinary .txt file. I am able to convert but I want the output to look as shown below in the .txt file table findhost= { {"xyz","abc"}, {"rxz","mmz"}, {"vrr","nnz"}, } default={"NONE"} My current perl script #!/usr/bin/env perl... (12 Replies)
Discussion started by: dbashyam
12 Replies

2. Shell Programming and Scripting

modify the test file by any script

Hi All the Helpers! I have a text file which looks like input.txt.I would request to please suggest me how can I make this file look like output.txt input.txt VOP 111 0 1 2 DEM 111 0 222 333 444 555 DEM 879 888 987 888 989 DEM 879 888 987 888 989 VOP 118 0 12 3 6... (7 Replies)
Discussion started by: Indra2011
7 Replies

3. Shell Programming and Scripting

Modify the text file by script

Hi All the Helpers! I have a text file which looks like input.txt.I would request to please suggest me how can I make this file look like output.txt input.txt VOP 111 0 1 2 DEM 111 0 222 333 444 555 879 888 987 888 989 VOP 118 0... (2 Replies)
Discussion started by: Indra2011
2 Replies

4. Shell Programming and Scripting

Shell script to modify file in several directories

Hi, I want a script shell to automate modifying httpd.conf file for several instances of apache, save httpd.file before changing it, after modifying it and then restart apache. - Replace ServerRoot "xxxx" by ServerRoot "yyyy" of all directories : "... (4 Replies)
Discussion started by: bras39
4 Replies

5. Shell Programming and Scripting

Modify text file using shell script

Hi, I have a text file which is following format - COL VAL ABC 1 ABC 2 ABC 3 ABC 4 ABC 5 My requirement is to search for a particular value (provided by user) in the file and comment the previous entries including that as well. E.g. If I search for number 3, then the output... (6 Replies)
Discussion started by: bhupinder08
6 Replies

6. Shell Programming and Scripting

Need to modify csv-file with bash script

Hi Guys, I need to write a script, that exports the "moz_places" table of the "places.sqlite"-file (firefox browser history) into a csv-file. That part works. After the export, my csv looks like this: ... 4429;http://www.sqlite.org/sqlite.html;"Command Line Shell For... (11 Replies)
Discussion started by: Sebi0815
11 Replies

7. Shell Programming and Scripting

How to modify the contents of file using script

Hi, Can anyone pls let me know how can i modify the file contents thru script. Eg. I have file abc.dat that contains below lines Merge.resync.cycleFlag Merge.resync.logFlag Merge.resync.maxByteRate Merge.resync.maxSearch Merge.resync.rate Merge.resync.tickLog ... (2 Replies)
Discussion started by: sdosanjh
2 Replies

8. Shell Programming and Scripting

Need to modify a file of different username through script.

Hi ! All I want to write a script where, it will open a new shell with a username / pwd and modify a file of same username and exit. example: 1. UserA 2. UserB- FileB ScriptA -> su UserB -> Modify FileB -> Exit ScriptA Can somebody give me a direction , on how to... (2 Replies)
Discussion started by: dashok.83
2 Replies

9. Shell Programming and Scripting

how to modify a file using shell script

Hi, i am using SuonOS and ksh. i need to add data into a file(s.txt) using a shell script. i have to pass 3 parameters and these 3 paramaters should add into the file at end of the file. File s.txt is look like, --------------------------------- column1|column2|column3 ... (1 Reply)
Discussion started by: syamkp
1 Replies

10. Shell Programming and Scripting

Modify script to generate a log file

I've seen several examples of scripts in thise forum about having a script generate a log file. I have a script that is run from cron and that monitors a file system for a specfic filename(s) and then performs some actions on them. Normally I call this script from another script (which the one... (2 Replies)
Discussion started by: heprox
2 Replies
Login or Register to Ask a Question