Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Match pattern1 in file, match pattern2, substitute value1 in line

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Match pattern1 in file, match pattern2, substitute value1 in line
# 1  
Old 08-02-2013
Match pattern1 in file, match pattern2, substitute value1 in line
not getting anywhere with this

an xml file contains multiple clients set up with same tags, different values.

I need to parse the file for client foo, and change the value of tag "64bit" from false to true.

Code:
cat clients.xml

<Client type"FIX">
<ClientName>foo</ClientName>
<ListeningPort>999</ListeningPort>
<SCompID>bar</SCompID>
<TCompID>baz</TCompID>
<MsgP>Alice</MsgP>
<Trace>true</Trace>
<Session type="NATIVE"/>
<64bit>false</64bit>
</Client>

<Client type"FIX">
<ClientName>alice</ClientName>
<ListeningPort>991</ListeningPort>
<SCompID>bar2</SCompID>
<TCompID>baz2</TCompID>
<MsgP>Alice</MsgP>
<Trace>true</Trace>
<Session type="NATIVE"/>
<64bit>false</64bit>
</Client>

i have so far only managed to output the 7 lines below my pattern, last one of which is the one i need to work on

Code:
bash-3.2$ cat clients.xml|awk 'a-->0;/ClientName.foo/{a=7}'
<ListeningPort>999</ListeningPort>
<SCompID>bar</SCompID>
<TCompID>baz</TCompID>
<MsgP>Alice</MsgP>
<Trace>true</Trace>
<Session type="NATIVE"/>
<64bit>false</64bit>

other method i am looking at is using sed

Code:
sed -r -e '/Name.foo/ { n ; s/false/true/ }' clients.xml

how can i move to the 7th line instead of next line
Last edited by jack.bauer; 08-02-2013 at 01:14 PM..
# 2  
Old 08-02-2013
Try the awk script below...
Code:
awk '/^<ClientName>foo<\/ClientName>$/,/^<\/Client>$/ {if($0 ~ "^<64bit>false</64bit>$") $0="<64bit>true</64bit>";print}' clients.xml

This User Gave Thanks to shamrock For This Post:
jack.bauer
# 3  
Old 08-02-2013
Quote:
Originally Posted by jack.bauer
Code:
sed -r -e '/Name.foo/ { n ; s/false/true/ }' clients.xml

how can i move to the 7th line instead of next line
That approach would work fine if it were modified to use the correct number of consecutive n commands.

That sed script does not require -r.

Regards,
Alister
This User Gave Thanks to alister For This Post:
jack.bauer
# 4  
Old 08-02-2013
Quote:
Originally Posted by shamrock
Try the awk script below...
Code:
awk '/^<ClientName>foo<\/ClientName>$/,/^<\/Client>$/ {if($0 ~ "^<64bit>false</64bit>$") $0="<64bit>true</64bit>";print}' clients.xml

works, thanks. had to tweak a little though

Code:
awk '/Name.foo/,/64bit/ {if($0 ~ "<64bit>false<\/64bit>") $0="<64bit>true<\/64bit>";print}' clients.xml

also came up with this that equally works

Code:
sed '/Name.foo/,/64bit/ s/64bit>false/64bit>true/'

Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Get lines which has pattern1, pattern2 and pattern3 in it

Version: RHEL 6.5 In the below text file, I want to find the lines which has the string JOHN , KATE and STEVE in it. The logic is to grep with an AND condition ie. get all lines with JOHN AND KATE AND STEVE $ cat sometext.txt PHILIP worked in HR JOHN along with KATE fixed several IT... (4 Replies)
Discussion started by: John K
4 Replies

2. UNIX for Dummies Questions & Answers

Help with AWK - Compare a field in a file to lookup file and substitute if only a match

I have the below 2 files: 1) Third field from file1.txt should be compared to the first field of lookup.txt. 2) If match found then third field, file1.txt should be substituted with the second field from lookup.txt. 3)Else just print the line from file1.txt. File1.txt:... (4 Replies)
Discussion started by: venalla_shine
4 Replies

3. Shell Programming and Scripting

Append text to line if begins with pattern1 AND does not end with pattern2

Hello, I'm looking for sed solution to change ... <li>keyword</li> <li>keyword <li>keyword</li> <li>keyword <li>keyword</li> ... to ... <li>keyword</li> <li>keyword</li> <li>keyword</li> <li>keyword</li> <li>keyword</li> ... I.e., if lines beginning with <li> do not end with... (3 Replies)
Discussion started by: pioavi
3 Replies

4. Shell Programming and Scripting

delete part of file from pattern1 to pattern2

Hi all! How can I delete all the text starting from <string1> to <string2> in all the .txt files of the folder "FOLDER" ? Thanks a lot! mjomba ... </s> <s> <w></w> </s> <s> ... to get: (1 Reply)
Discussion started by: mjomba
1 Replies

5. Shell Programming and Scripting

Search file for pattern2 starting from occurence of pattern1

Hi folks, I have a file which contains several occurences of 2 different patterns. I need to find out the line of first occurence of pattern2 starting after the position of first occurence of pattern1. example file: aaaa pattern2 bbbb pattern1 ccc pattern2 ddd pattern1 eee pattern2... (9 Replies)
Discussion started by: sameucho
9 Replies

6. Shell Programming and Scripting

How to remove a specific line matching pattern1 and pattern2 ?

Hi, I have a file like below: . . . . Jack is going home Jack is going to school Jack is sleeping Jack is eating dinner John is going home John is eating breakfast . . . The specific line is: Jack is going home (2 Replies)
Discussion started by: salih81
2 Replies

7. Shell Programming and Scripting

Sed Help.To Search Between Pattern1 And Pattern2 Containing Certain Text

Hi, Here is a sample of my Test File $ cat TestFile1 Prompt Table DQZ_ALTER_SCHEMA_ID; ALTER TABLE DQZ.DQZ_ALTER_SCHEMA_ID MONITORING; ALTER TABLE DQZ.DQZ_ALTER_SCHEMA_ID STORAGE ( NEXT 3464K ); Prompt Table DQZ_ALTER_SCHEMA_ID; ALTER TABLE DQZ.DQZ_ALTER_SCHEMA_ID MOVE LOB... (16 Replies)
Discussion started by: rajan_san
16 Replies

8. Shell Programming and Scripting

SED Exclude Matches Between Pattern1 And Pattern2 Containing Pattern3 Print The Rest

Hi, From the sample file below Conditions 1) Pattern Range must start with "ALTER TABLE" 2) Pattern Range ends when it finds ";" 3) Between this range i want to select all the patterns that contain pattern " MOVE " Note : I would like to exclude the above pattern matches and print... (1 Reply)
Discussion started by: rajan_san
1 Replies

9. Shell Programming and Scripting

grep all lines from PATTERN1 to PATTERN2

Hi! From a file like this one : hello ... PATTERN1 ... lines between patterns .. PATTERN2 ... I would like to extract only the lines between patterns, probably with awk I think? Thanks a lot for your help, Tipi (5 Replies)
Discussion started by: tipi
5 Replies

10. Shell Programming and Scripting

how to delete text from line starting pattern1 up to line before pattern2?

My data is xml'ish (here is an excerpt) :- <bag name="mybag1" version="1.0"/> <contents id="coins"/> <bag name="mybag2" version="1.1"/> <contents id="clothes"/> <contents id="shoes"/> <bag name="mybag3" version="1.6"/> I want to delete line containing mybag2 and its subsequent... (5 Replies)
Discussion started by: repudi8or
5 Replies
Login or Register to Ask a Question