02-11-2013
Compare two xml files while ignoring some xml tags
I've got two different files and want to compare them.
File 1 :
HTML Code:
<response ticketId="944" type="getQueryResults"><status>COMPLETE</status><description>Query results fetched successfully</description><recordSet totalCount="1" type="sms_records"><record id="38,557"><columns><column><name>orge SMS call NO</name><value><![CDATA[message_id-13]]></value></column><column><name>username</name><value><![CDATA[ci_user-13]]></value></column><column><name>SENT TO</name><value><![CDATA[to_address-13]]></value></column><column><name>REPLY-TO ADDRESS</name><value><![CDATA[reply_to_address-13]]></value></column><column><name>TIME SENT</name><value><![CDATA[2010-08-08 21:47:40.274 UTC]]></value></column><column><name>TIME CLOSED</name><value><![CDATA[2010-08-08 22:08:16.216 UTC]]></value></column><column><name>STATE</name><value><![CDATA[state-13]]></value></column><column><name>REFUNDED</name><value><![CDATA[no]]></value></column><column><name>CLIENT IP</name><value><![CDATA[87.200.199.226]]></value></column><column><name>CURRENCY</name><value><![CDATA[key_ccy]]></value></column><column><name>PRICE</name><value><![CDATA[001.107]]></value></column></columns></record></recordSet></response>
File 2 :
HTML Code:
<response ticketId="944" type="getQueryResults"><status>COMPLETE</status><description>Query results fetched successfully</description><recordSet totalCount="1" type="sms_records"><record id="38,557"><columns><column><name>orge SMS call NO</name><value><![CDATA[message_id-13]]></value></column><column><name>username</name><value><![CDATA[ci_user-13]]></value></column><column><name>SENT TO</name><value><![CDATA[to_address-13]]></value></column><column><name>REPLY-TO ADDRESS</name><value><![CDATA[reply_to_address-13]]></value></column><column><name>TIME SENT</name><value><![CDATA[2010-08-08 21:47:40.274 UTC]]></value></column><column><name>TIME CLOSED</name><value><![CDATA[2010-08-08 22:08:16.216 UTC]]></value></column><column><name>STATE</name><value><![CDATA[state-13]]></value></column><column><name>REFUNDED</name><value><![CDATA[no]]></value></column><column><name>CLIENT IP</name><value><![CDATA[87.200.199.226]]></value></column><column><name>CURRENCY</name><value><![CDATA[key_ccy]]></value></column><column><name>PRICE</name><value><![CDATA[001.107]]></value></column></columns></record></recordSet></response>
Now I am comparing this two files but want to ignore specific tags e.g. <ticketId="944"> and <totalCount="1">
How can i copmare two files while ignoring above values ?
10 More Discussions You Might Find Interesting
1. UNIX for Advanced & Expert Users
All,
PLease can you help me with a shell script which can compare two xml files and print the difference to a output file.
I have attached one such file for you reference.
<Group>
<Member ID=":Year_Quad:41501" childCount="4" fullPath="PEPSICO Year-Quad-Wk : FOLDER.52 Weeks Ending Dec... (2 Replies)
Discussion started by: kanthrajgowda
2 Replies
2. Shell Programming and Scripting
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
3. Shell Programming and Scripting
I've got two different files and want to compare them.
File 1 :
HTML Code:
<response ticketId="944" type="getQueryResults"><status>COMPLETE</status><description>Query results fetched successfully</description><recordSet totalCount="1" type="sms_records"><record... (1 Reply)
Discussion started by: Shaishav Shah
1 Replies
4. Shell Programming and Scripting
Hi ,
I have a below xml:
<ns:Body>
<ns:result>
<Date Month="June" Day="Monday:/>
</ns:result>
</ns:Body>
i have a lookup abc.txtt text file with below details
Month June July August
Day Monday Tuesday Wednesday
I need a output xml with below tags
<ns:Body>
<ns:result>... (2 Replies)
Discussion started by: Nevergivup
2 Replies
5. Shell Programming and Scripting
Hi,
I want to comapre two xml files in unix.
1st xml file contents
<application> abc </application>
<type>2</type>
<type1>3</type1>
2nd xml file contents.
<application> abc</application>
<type>2</type>
<type1>1</type1>
<type2>567</type2>
Desired output
Differences in 1st file... (2 Replies)
Discussion started by: DeepaT
2 Replies
6. Shell Programming and Scripting
I have two files for comparison which are extracts from set of xml files.
file1 has:
Comparing File: BRCSH1to320140224CC3.xml
:: TZZZ:BR
:: TAZZ:OUT
UIZZ:0 :: ERAZ:1.000000
UIZZ:0 :: CTZZ:B
UIZZ:0 :: CCAZ:MYR
Comparing File: BRMY20140224CC18REG013SPFNSY13.xml
:: TZZZ:BR
:: TAZZ:INB... (1 Reply)
Discussion started by: vamsi gunda
1 Replies
7. Shell Programming and Scripting
Hello everybody,
I have a double mission with some XML files, which is pretty challenging for my actual beginner UNIX knowledge. I need to extract some strings from multiple XML files and create a new XML file with the searched strings..
The original XML files contain the source code for... (12 Replies)
Discussion started by: milano.churchil
12 Replies
8. Shell Programming and Scripting
Hi Everyone,
I'm new here and I was checking this old post:
/shell-programming-and-scripting/180669-splitting-file-into-several-smaller-files-using-perl.html
(cannot paste link because of lack of points)
I need to do something like this but understand very little of perl.
I also check... (4 Replies)
Discussion started by: mcosta
4 Replies
9. Shell Programming and Scripting
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
10. UNIX for Beginners Questions & Answers
I'm searching for the names of a TV show in the XML file I've attached at the end of this post. What I'm trying to do now is pull out/list the data from each of the <SeriesName> tags throughout the document. Currently, I'm only able to get data the first instance of that XML field using the... (9 Replies)
Discussion started by: hungryd
9 Replies