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
docbook2gjots
DOCBOOK2GJOTS(1) General Commands Manual DOCBOOK2GJOTS(1)
NAME
docbook2gjots - Convert a DOCBOOK file to gjots format (on stdout)
SYNOPSIS
docbook2gjots [ DOCBOOK-file ]
DESCRIPTION
docbook2gjots converts a DOCBOOK XML file into gjots format.
docbook2gjots uses gawk(1) to perform the conversion.
<preface>, <chapter>, <section>, <sect1>, <sect2>, <sect3> and <sect4> tags are used to define NewEntry and NewFolder boundaries. They
should definitely have <title> tags.
This is a quick and dirty hack using gawk(1) and does no formal checking of XML or SGML syntax nor does it validate against the DOCBOOK
DTD. Consequently, if the syntax of the file is broken the conversion will probably fail.
It is intended that a round-trip can be made so that gjots(1) can be used as a tool at all stages of DOCBOOK production - mainly as an out-
line processor to help the author organise and order the work. A document may well start its life in gjots(1) as the initial thoughts are
marshalled. As the document forms up, it can be converted to DOCBOOK with the following command which automatically adds tags such as
<?xml...>, <para> etc:
gjots2docbook -b file.gjots >file.xml
docbook2pdf file.xml
Or, starting with an existing DOCBOOK file:
docbook2gjots file.xml >file.gjots
In the latter case, the document will already have a lot of DOCBOOK tags so to convert back to docbook, add the -e and -p options:
gjots2docbook -b -p -e file.gjots >file.xml
docbook2pdf file.xml
AUTHOR
Written by Bob Hepple <bhepple@freeshell.org>
http://bhepple.freeshell.org/gjots
COPYRIGHT
Copyright (c) 2002 Robert Hepple
This is free software; see the source for copying conditions. There is NO warranty; not even for MERCHANTABILITY or FITNESS FOR A PAR-
TICULAR PURPOSE.
SEE ALSO
gjots(1), gjots2html(1), gjots2docbook(1)
DOCBOOK2GJOTS(1)