02-11-2013
Shell Command to compare two xml lines while ignoring 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="1002" 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. Shell Programming and Scripting
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
2. Shell Programming and Scripting
Hi All,
Good day
Here is my data:
<Journal>
<JournalCode>2</JournalCode>
<JournalType>L</JournalType>
<JournalEntry>SG</JournalEntry>
<JournalAmount>-0.05</JournalAmount>
</Journal>
Problem:
1) I need to query the above tags in xml. Which is from the header <Journal>... (4 Replies)
Discussion started by: lutinoman
4 Replies
3. Shell Programming and Scripting
I have existing XML file as below, now based on input string in shell script on workordercode i need to create a seprate xml file
for e.g if we pass the input string as 184851 then it find the tag data from <workOrder>..</workOrder> and write to a new file and similarly next time if i pass the... (3 Replies)
Discussion started by: balrajg
3 Replies
4. 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
5. 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
6. Shell Programming and Scripting
I've got two different files and want to compare them.
File 1 :
<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... (2 Replies)
Discussion started by: Shaishav Shah
2 Replies
7. 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
8. Shell Programming and Scripting
Hi All,
My name is Prathyu and I am working as a ETL develper. I have one requirement to create a XML file based on the provided XSD file. As per the Datastage standards Key(repeatable) field does not contain any Null values so I am inserting some dummy tag line to that XML file.
... (14 Replies)
Discussion started by: Prathyu
14 Replies
9. Shell Programming and Scripting
<Start>
<Header>
This is header section
</Header>
<Body>
<Body_start>
This is body section
<a>
<b>
<c>
<st>111</st>
</c>
<d>
<st>blank</st>
</d>
</b>
</a>
</Body_start>
<Body_section>
This is body section (3 Replies)
Discussion started by: RJG
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
LEARN ABOUT OPENSOLARIS
tiffcmp
tiffcmp(1) User Commands tiffcmp(1)
NAME
tiffcmp - compare two TIFF files
SYNOPSIS
tiffcmp [options] file1.tif file2.tif
DESCRIPTION
tiffcmp compares the tags and data in two files created according to the Tagged Image File Format, Revision 6.0. The schemes used for com-
pressing data in each file are immaterial when comparing data. Files are compared on a scanline-by-scanline basis after decompression. Most
directory tags are checked, notable exceptions are GrayResponseCurve, ColorResponseCurve, and ColorMap tags. Data is not compared if any of
the BitsPerSample, SamplesPerPixel, or ImageWidth values are not equal. By default, tiffcmp terminates if any difference is encountered.
OPTIONS
The following options are supported:
-l List each byte of image data that differs between the files.
-t Ignore any differences in directory tags.
OPERANDS
The following operands are supported:
filex.tif The names of the TIFF files to be compared.
ATTRIBUTES
See attributes(5) for descriptions of the following attributes:
+-----------------------------+-----------------------------+
| ATTRIBUTE TYPE | ATTRIBUTE VALUE |
+-----------------------------+-----------------------------+
|Availability |SUNWTiff |
+-----------------------------+-----------------------------+
|Interface stability |Uncommitted |
+-----------------------------+-----------------------------+
SEE ALSO
pal2rgb(1), tiffinfo(1), tiffcp(1), tiffmedian(1), libtiff(3)
NOTES
Tags that are not recognized by the library are not compared. Such tags may also generate spurious diagnostics.
Updated by Breda McColgan, Sun Microsystems Inc., 2004.
SunOS 5.11 26 Mar 2004 tiffcmp(1)