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 DEBIAN
net::epp::frame::command::delete::domain
Net::EPP::Frame::Command::Delete::Domain(3pm) User Contributed Perl Documentation Net::EPP::Frame::Command::Delete::Domain(3pm)
NAME
Net::EPP::Frame::Command::Delete::Domain - an instance of Net::EPP::Frame::Command::Delete for domain names.
SYNOPSIS
use Net::EPP::Frame::Command::Delete::Domain;
use strict;
my $delete = Net::EPP::Frame::Command::Delete::Domain->new;
$delete->setDomain('example.tld');
print $delete->toString(1);
This results in an XML document like this:
<?xml version="1.0" encoding="UTF-8"?>
<epp xmlns="urn:ietf:params:xml:ns:epp-1.0"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="urn:ietf:params:xml:ns:epp-1.0
epp-1.0.xsd">
<command>
<delete>
<domain:delete
xmlns:domain="urn:ietf:params:xml:ns:domain-1.0"
xsi:schemaLocation="urn:ietf:params:xml:ns:domain-1.0
domain-1.0.xsd">
<domain:name>example.tldE<lt>/domain:name>
</domain:delete>
</delete>
<clTRID>0cf1b8f7e14547d26f03b7641660c641d9e79f45</clTRIDE<gt>
</command>
</epp>
OBJECT HIERARCHY
L<XML::LibXML::Node>
+----L<XML::LibXML::Document>
+----L<Net::EPP::Frame>
+----L<Net::EPP::Frame::Command>
+----L<Net::EPP::Frame::Command::Delete>
+----L<Net::EPP::Frame::Command::Delete::Domain>
METHODS
$frame->setDomain($domain_name);
This specifies the domain name to be deleted.
AUTHOR
CentralNic Ltd (http://www.centralnic.com/).
COPYRIGHT
This module is (c) 2012 CentralNic Ltd. This module is free software; you can redistribute it and/or modify it under the same terms as Perl
itself.
SEE ALSO
o Net::EPP::Frame
perl v5.14.2 2012-04-23 Net::EPP::Frame::Command::Delete::Domain(3pm)