Compare two xml files while ignoring some xml tags

Shaishav Shah · #1 02-11-2013

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>&lt;![CDATA[message_id-13]]&gt;</value></column><column><name>username</name><value>&lt;![CDATA[ci_user-13]]&gt;</value></column><column><name>SENT TO</name><value>&lt;![CDATA[to_address-13]]&gt;</value></column><column><name>REPLY-TO ADDRESS</name><value>&lt;![CDATA[reply_to_address-13]]&gt;</value></column><column><name>TIME SENT</name><value>&lt;![CDATA[2010-08-08 21:47:40.274 UTC]]&gt;</value></column><column><name>TIME CLOSED</name><value>&lt;![CDATA[2010-08-08 22:08:16.216 UTC]]&gt;</value></column><column><name>STATE</name><value>&lt;![CDATA[state-13]]&gt;</value></column><column><name>REFUNDED</name><value>&lt;![CDATA[no]]&gt;</value></column><column><name>CLIENT IP</name><value>&lt;![CDATA[87.200.199.226]]&gt;</value></column><column><name>CURRENCY</name><value>&lt;![CDATA[key_ccy]]&gt;</value></column><column><name>PRICE</name><value>&lt;![CDATA[001.107]]&gt;</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>&lt;![CDATA[message_id-13]]&gt;</value></column><column><name>username</name><value>&lt;![CDATA[ci_user-13]]&gt;</value></column><column><name>SENT TO</name><value>&lt;![CDATA[to_address-13]]&gt;</value></column><column><name>REPLY-TO ADDRESS</name><value>&lt;![CDATA[reply_to_address-13]]&gt;</value></column><column><name>TIME SENT</name><value>&lt;![CDATA[2010-08-08 21:47:40.274 UTC]]&gt;</value></column><column><name>TIME CLOSED</name><value>&lt;![CDATA[2010-08-08 22:08:16.216 UTC]]&gt;</value></column><column><name>STATE</name><value>&lt;![CDATA[state-13]]&gt;</value></column><column><name>REFUNDED</name><value>&lt;![CDATA[no]]&gt;</value></column><column><name>CLIENT IP</name><value>&lt;![CDATA[87.200.199.226]]&gt;</value></column><column><name>CURRENCY</name><value>&lt;![CDATA[key_ccy]]&gt;</value></column><column><name>PRICE</name><value>&lt;![CDATA[001.107]]&gt;</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 ?

sizemj · #2 02-11-2013

I would use "diff"
UNIX man pages : diff ()

fpmurphy · #3 02-12-2013

There is no free tool out there that will allow you to compare two XML files whilst selectively ignoring some tags.

Simpliest approach would be turn both XML files into canonical XML files, and compare the results using diff.

Thread Tools	Search this Thread
Show Printable Version Email this Page Subscribe to this Thread	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
find un-closed tags in XML files	unme	Shell Programming and Scripting	3	01-04-2013 04:53 AM
How to add the multiple lines of xml tags before a particular xml tag in a file	mjavalkar	Shell Programming and Scripting	0	06-25-2012 04:54 PM
Shell Script to compare xml files and print output to a file	kanthrajgowda	UNIX for Advanced & Expert Users	2	03-28-2011 11:23 AM
Renaming files with strings from xml tags	degoor	Windows & DOS: Issues & Discussions	3	12-31-2009 06:00 AM
How to remove xml namespace from xml file using shell script?	Gary1978	Shell Programming and Scripting	10	10-26-2008 09:32 PM