Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

How to substitute a line that matches an expression with another line

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting How to substitute a line that matches an expression with another line
# 1  
Old 02-17-2011
How to substitute a line that matches an expression with another line
I need some help. I have a file (all.txt) whereby I want to substitute using sed/awk all lines that matches an expression with another line with different expression i.e
subtitute expression,
database_id: filename;
WITH
database_id: PY;

There are many occurrences of the expression "database_id: filename;" in the file all.txt,with filename having various values.

Attached is the file all.txt
all.txt (434.5 KB) 
# 2  
Old 02-17-2011
So basically you want to replace all occurrences of "database_id:" with value other than "PY" to "database_id: PY;"?
# 3  
Old 02-17-2011
Yes! any line that starts with 'database_id:' should be replaced to database_id: PY;
# 4  
Old 02-17-2011
Code:
perl -i -pe 's/database_id: .*/database_id: PY;/' all.txt

It will edit the file in place.
This User Gave Thanks to bartus11 For This Post:
aimsoft
# 5  
Old 02-17-2011
Thank you very much!! It has worked..thank you.
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Linux

Print line 1 if line 3 matches of the output

Hi I want to extend following command so that on the basis of "Branch: ****" on the third line I can grep and print name of the file on the first line. cat .labellog.emd | grep DA2458A7962276A7E040E50A0DC06459 | cut -d " " -f2 | grep -v branch_name | xargs -I file <command to describe> file ... (1 Reply)
Discussion started by: ezee
1 Replies

2. Shell Programming and Scripting

awk to print the line that matches and the next if line is wrapped

I have a file and when I match the word "initiators" in the first column I need to be able to print the rest of the columns in that row. This is fine for the most part but on occasion the "initiators" line gets wrapped to the next line. Here is a sample of the file. caw-enabled ... (3 Replies)
Discussion started by: kieranfoley
3 Replies

3. Shell Programming and Scripting

Using regex's from file1, print line and line after matches in file2

Good day, I have a list of regular expressions in file1. For each match in file2, print the containing line and the line after. file1: file2: Output: I can match a regex and print the line and line after awk '{lines = $0} /Macrosiphum_rosae/ {print lines ; print lines } ' ... (1 Reply)
Discussion started by: pathunkathunk
1 Replies

4. UNIX for Dummies Questions & Answers

print line that matches and next line, too

I'm using sh on hp-ux and want to find / print a line that matches 132.101- and the next line, too. grep -A isn't supported on hp-ux, so I'm trying awk and sed. The code below works but only prints the first occurence. I need all matches from the file. awk... (2 Replies)
Discussion started by: Scottie1954
2 Replies

5. Shell Programming and Scripting

substitute a line in a file if line number is available

Hi guys, is there are way to substitute the content of certain line in the file by another entry if line number is available? For example, I have a variable A="HCMLPBBG" and a file MYFILE. I need to substitute entry on line 18168 of MYFILE with the value of the variable "A". Is there a way to... (1 Reply)
Discussion started by: aoussenko
1 Replies

6. UNIX for Dummies Questions & Answers

if line matches then

I have a file that I need to read each line and see if the line begins with a certain keyword. I can't seem to find something that works. #!/bin/ksh # while read i do if ] then echo "SE2 WORKS" elif ] then echo "CISCO1 WORKS" fi done < tmp/diff The file looks something like SE1 SE2... (2 Replies)
Discussion started by: numele
2 Replies

7. Shell Programming and Scripting

Print word 1 in line 1 and word 2 in line 2 if it matches a pattern

i have a file in this pattern MATCH1 word1 IMAGE word3 word4 MATCH2 word1 word2 word3 word4 MATCH2 word1 word2 word3 word4 MATCH2 word1 word2 word3 word4 MATCH2 word1 word2 word3 word4 MATCH1 word1 IMAGE word3 word4 MATCH2 word1 word2 word3 word4 MATCH2 word1 word2 word3 word4 MATCH2 word1... (7 Replies)
Discussion started by: bangaram
7 Replies

8. UNIX for Advanced & Expert Users

Inserting a line before the line which matches the patter

Hi Is there any command where we can insert a line "2|||" before every line starting with "3|" my input is as follows 1|ETG|12345 3|79.58|||GBP|| 1|ETG|12345 3|79.58|||GBP|| 1|ETG|12345 2|EN_GB||Electrogalvanize 0.5 m2 ( Renault ) 1|ETG|12345 3|88.51|||GBP|| desired output... (10 Replies)
Discussion started by: laxmi131
10 Replies

9. Shell Programming and Scripting

substitute a line in file

i have an file ,i want to substitute line 003 M 33 22 22 00 WITH NEW 003 M 24 26 28 00 how can i do it (2 Replies)
Discussion started by: RahulJoshi
2 Replies

10. Shell Programming and Scripting

grep the line only if next line matches

Hi I have an Input of following sort AAAA: ProgName="PROGRAM" BBBB: ProgName="BBBBBB" CCCC: DDDD: ProgName="PROGRAM" SSSS: ProgName="PROGRAM" ZZZZ: ProgName="PROGRAM" I want to find the Lines which are followed by ProgName="PROGRAM" Out Put AAAA: (11 Replies)
Discussion started by: pbsrinivas
11 Replies
Login or Register to Ask a Question