Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Editing XML file

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Editing XML file
# 1  
Old 05-11-2011
Error Editing XML file
Hi All,

i have an XML file like :-

<RequestBillsRsp version="1.0"><BillSummaryData><AgreementNumberFull>13-WY-8425-2</AgreementNumberFull><AgreementNumberAbbr>WY84252</AgreementNumberAbbr><LineOfBusiness>F</LineOfBusiness><Line></Line>

This is a continuous pattern. From this I need to extract the values only. Output should be

13-WY-8425-2
WY84252
F
blank

Please if nothing is available in between braces, it should print as "blank"

please help me out ..

Thanks
Ren
# 2  
Old 05-11-2011
Code:
cat test.txt |awk -F '>' '{print $2}' | awk -F '<'  '{ if (  $2 == "" ) print "blank";else print $1 }'

# 3  
Old 05-11-2011
Really weird, three threads, same xml file, three users!

https://www.unix.com/shell-programmin...scripting.html
https://www.unix.com/shell-programmin...-xml-file.html
https://www.unix.com/shell-programmin...e-parsing.html

regards,
Ahamed
# 4  
Old 05-11-2011
This will work if the pattern is not continous. But XML is not coming as line by line. Like below :-

<RequestBillsRsp version="1.0"><BillSummaryData><AgreementNumberFull>13-WY-8425-2</AgreementNumberFull><AgreementNumberAbbr>WY84252</AgreementNumberAbbr><LineOfBusiness>F</LineOfBusiness>

In this case, what ever you suggested will not work. Please take a look
Last edited by Renjesh; 05-11-2011 at 11:24 AM..
# 5  
Old 05-11-2011
Give a try with
Code:
sed 's:<\([^>]*>\)</\1:blank:g;s/<[^>]*>/#/g;s/##*/#/g;s/^#//' infile.xml | tr '#' '\n'

---------- Post updated at 04:37 PM ---------- Previous update was at 04:32 PM ----------

Code:
# cat tst.xml
<RequestBillsRsp version="1.0"><BillSummaryData><AgreementNumberFull>13-WY-8425-2</AgreementNumberFull><AgreementNumberAbbr>WY84252</AgreementNumberAbbr><LineOfBusiness>F</LineOfBusiness><Line></Line>

Code:
# sed 's:<\([^>]*>\)</\1:blank:g;s/<[^>]*>/#/g;s/##*/#/g;s/^#//' tst.xml | tr '#' '\n'
13-WY-8425-2
WY84252
F
blank

# 6  
Old 05-12-2011
Renjesh,

Please explain why these three threads from you and two other
users which Ahamed101 listed in Post #3 above use the same XML
file and seem to be related.
# 7  
Old 05-12-2011
Maybe that's a very popular XML code...Smilie

---------- Post updated at 11:26 AM ---------- Previous update was at 09:38 AM ----------
Last edited by xtatic; 05-12-2011 at 07:46 AM..
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

Grepping multiple XML tag results from XML file.

I want to write a one line script that outputs the result of multiple xml tags from a XML file. For example I have a XML file which has below XML tags in the file: <EMAIL>***</EMAIL> <CUSTOMER_ID>****</CUSTOMER_ID> <BRANDID>***</BRANDID> Now I want to grep the values of all these specified... (1 Reply)
Discussion started by: shubh752
1 Replies

2. Shell Programming and Scripting

Splitting a single xml file into multiple xml files

Hi, I'm having a xml file with multiple xml header. so i want to split the file into multiple files. Sample.xml consists multiple headers so how can we split these multiple headers into multiple files in unix. eg : <?xml version="1.0" encoding="UTF-8"?> <ml:individual... (3 Replies)
Discussion started by: Narendra921631
3 Replies

3. Shell Programming and Scripting

Split xml file into multiple xml based on letterID

Hi All, We need to split a large xml into multiple valid xml with same header(2lines) and footer(last line) for N number of letterId. In the example below we have first 2 lines as header and last line as footer.(They need to be in each split xml file) Header: <?xml version="1.0"... (5 Replies)
Discussion started by: vx04
5 Replies

4. Shell Programming and Scripting

Comparing delta values of one xml file in other xml file

Hi All, I have two xml files. One is having below input <NameValuePair> <name>Daemon</name> <value>tcp:7474</value> </NameValuePair> <NameValuePair> <name>Network</name> <value></value> </NameValuePair> ... (2 Replies)
Discussion started by: sharsour
2 Replies

5. UNIX for Dummies Questions & Answers

XML File editing in HP-UX

Hi All, I have attached the original file and the file that I have edited, please have a look. The files are named as follows original.xml and updated.xml The chunk of data that we don’t we need is below At the start of the file: The below data is not required <Data... (3 Replies)
Discussion started by: srikaka
3 Replies

6. Shell Programming and Scripting

Help required in Splitting a xml file into multiple and appending it in another .xml file

HI All, I have to split a xml file into multiple xml files and append it in another .xml file. for example below is a sample xml and using shell script i have to split it into three xml files and append all the three xmls in a .xml file. Can some one help plz. eg: <?xml version="1.0"?>... (4 Replies)
Discussion started by: ganesan kulasek
4 Replies

7. Shell Programming and Scripting

How to add the multiple lines of xml tags before a particular xml tag in a file

Hi All, I'm stuck with adding multiple lines(irrespective of line number) to a file before a particular xml tag. Please help me. <A>testing_Location</A> <value>LA</value> <zone>US</zone> <B>Region</B> <value>Russia</value> <zone>Washington</zone> <C>Country</C>... (0 Replies)
Discussion started by: mjavalkar
0 Replies

8. Shell Programming and Scripting

Help in Editing XML files

I need some help in editing a xml file, I have 2 xml files, One is Master.xml and other is a upgrade.xml. I want to moved all the values from upgrade.xml to Master.xml. challenge is upgrade.xml might have similar values, changed values and also new values. So the script should find and replace or... (1 Reply)
Discussion started by: pradeepmacha
1 Replies

9. Shell Programming and Scripting

editing a xml file

I have a xml file which conttent as follows: <Config><Pro><config> <key>mac</key> <value>localhost</value> </config> </Pro></Config> i want to edit <value>localhost</value> as <value>local</value> can any one please help me on... (3 Replies)
Discussion started by: Aditya.Gurgaon
3 Replies

10. Shell Programming and Scripting

How to remove xml namespace from xml file using shell script?

I have an xml file: <AutoData xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"> <Table1> <Data1 10 </Data1> <Data2 20 </Data2> <Data3 40 </Data3> <Table1> </AutoData> and I have to remove the portion xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" only. I tried using sed... (10 Replies)
Discussion started by: Gary1978
10 Replies
Login or Register to Ask a Question