Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: How to add Xml tags to an existing xml using shell or awk?
Top Forums Shell Programming and Scripting How to add Xml tags to an existing xml using shell or awk? Post 302783815 by Nevergivup on Thursday 21st of March 2013 03:40:35 AM
Old 03-21-2013
How to add Xml tags to an existing xml using shell or awk?
Hi ,

I have a below xml:
Code:
<ns:Body>
<ns:result>
<Date Month="June"  Day="Monday:/>
</ns:result>
</ns:Body>


i have a lookup abc.txtt text file with below details
Code:
Month  June July August
Day    Monday Tuesday Wednesday

I need a output xml with below tags
Code:
<ns:Body>
<ns:result>
<Date Month="June"  Day="Monday:/>
<Date Month="July"  Day="Tuesday:/>
<Date Month="August"  Day="Wednesday:/>
</ns:result>
</ns:Body>

How can i achieve it using awk or shell scripting
Last edited by Franklin52; 03-21-2013 at 07:11 AM.. Reason: Please use code tags for data and code samples
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

script to run shell command and insert results to existing xml file

Hi. Thanks for any help with this. I'm not new to programming but I am new to shell programming. I need a script that will 1. execute 'df -k' and return the volume names with specific text 2. surround each line of the above results in opening and closing xml tags 3. insert the results of step... (5 Replies)
Discussion started by: littlejon
5 Replies

2. Shell Programming and Scripting

How to remove xml namespace from xml file using shell script?

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

3. Shell Programming and Scripting

how to search xml tags using unix shell

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

4. Shell Programming and Scripting

Read content between xml tags with awk, grep, awk or what ever...

Hello, I trying to extract text that is surrounded by xml-tags. I tried this cat tst.xml | egrep "<SERVER>.*</SERVER>" |sed -e "s/<SERVER>\(.*\)<\/SERVER>/\1/"|tr "|" " " which works perfect, if the start-tag and the end-tag are in the same line, e.g.: <tag1>Hello Linux-Users</tag1> ... (5 Replies)
Discussion started by: Sebi0815
5 Replies

5. Shell Programming and Scripting

awk to retrieve the particular value from a same list of xml tags

Hi All, I have the following code in one of my xml file: <com:parameter> <com:name>secretKey</com:name> <com:value>31XA874821172E89B00B1C</com:value> </com:parameter> <com:parameter> <com:name>tryDisinfect</com:name> <com:value>false</com:value> </com:parameter> <com:parameter>... (4 Replies)
Discussion started by: mjavalkar
4 Replies

6. Shell Programming and Scripting

How to add the multiple lines of xml tags before a particular xml tag in a file

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

7. Shell Programming and Scripting

awk and or sed command to sum the value in repeating tags in a XML

I have a XML in which <Amt Ccy="EUR">3.1</Amt> tag repeats. This is under another tag <Main>. I need to sum all the values of <Amt Ccy=""> (Ccy may vary) coming under <Main> using awk and or sed command. can some help? Sample looks like below <root> <Main> ... (6 Replies)
Discussion started by: bk_12345
6 Replies

8. Shell Programming and Scripting

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... (1 Reply)
Discussion started by: Shaishav Shah
1 Replies

9. Shell Programming and Scripting

Compare two xml files while ignoring some xml tags

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

10. UNIX for Beginners Questions & Answers

How to pull multiple XML tags from the same XML file in Shell.?

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

mono-xmltool

mono-xmltool(Mono 1.0)													    mono-xmltool(Mono 1.0)

NAME

       mono-xmltool - Mono XML validation and transformation tool.

SYNOPSIS

       mono-xmltool --validate [*.rng | *.rnc | *.nvdl | *.xsd] [instances]

       mono-xmltool --validate-rng relax-ng-grammar-xml [instances]

       mono-xmltool --validate-rnc relax-ng-compact-grammar-file [instances]

       mono-xmltool --validate-nvdl nvdl-script-xml [instances]

       mono-xmltool --validate-xsd xml-schema [instances]

       mono-xmltool --transform stylesheet instance-xml

       mono-xmltool --prettyprint [source [result]]

DESCRIPTION

       mono-xmltool is a command line front end for various functions available in the Mono XML class libraries. It currently it offers validation
       with various different kinds of schemas, xslt transformations and pretty printing.

XML VALIDATION

       mono-xmltool can validate a given set of XML files (the instances parameter) using the given schema file.  Currently supported schema files
       include Relax NG (*.rng), Compact Relax NG (*.rnc), Namespace-based Validation Dispatching Language (*.nvdl) and XML Schema (*.xsd).

       If invoked with the --validate argument, Mono will use the filename extension to guess the kind of validation required.	The --validate-xxx
       flags would force a specific kind of validation.

       The following lists the flags and the actual class that implements them in Mono:

       --validate-rng

	      Commons.Xml.Relaxng.RelaxNgPattern as the schema, and Commons.Xml.Relaxng.RelaxngValidatingReader validator.

       --validate-rnc
	      Commons.Xml.Relaxng.RncParser as the schema, and Commons.Xml.Relaxng.RelaxngValidatingReader validator.

       --validate-nvdl

	      Commons.Xml.Nvdl as the schema and Commons.Xml.NvdlValidatingReader validator.

       --validate-xsd
	      System.Xml.Schema.XmlSchema as the schema and uses System.Xml.XmlValidatingReader as the validator.

TRANSFORMATIONS

       This does an XSLT transformation. The stylesheet must be an XSLT file, the instance-xml is the document to be processed.  Output it sent to
       the standard output.

PRETTY PRINTING

       Produces  a  pretty-print  rendering of the source file.  If it is not specified it reads the standard input.   If result is not specified,
       the output is sent to the standard output.

MAILING LISTS

       Mailing lists are listed at the http://www.mono-project.com/Mailing_Lists

WEB SITE

       http://www.mono-project.com

SEE ALSO

       mono(1),mcs(1).

															    mono-xmltool(Mono 1.0)
All times are GMT -4. The time now is 10:26 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy