Shell script to extract data in repeating tags from xml
Hi,
I am new to shell scripting. I need to extract data between repeating tags from an xml file and store the data in an array to process it further.
I need to extract the data in the operation tag to an array and later process each of the tags further. Can some one please help me to write a bash script for this?
Thanks
Sai.
Last edited by Scrutinizer; 09-08-2012 at 10:21 AM..
Reason: code tags
Hi,
This is the xml file that i have.
- <front-servlet platform="WAS4.0" request-retriever="SiteMinder-aware" configuration-rescan-interval="60000">
<concurrency-throttle maximum-concurrency="50" redirect-page="/jsp/defaulterror.jsp" />
- <loggers>
<instrumentation... (5 Replies)
Hello Scripting Gurus,
I need help with extracting data from the XML file using shell script.
The data is in a large XML and I need to extract the id values of all completedworkflows. Here is a sample of it. Input and output data is also in the attached text files.
<wfregistry>... (5 Replies)
Hi All, Prepare a perl script for extracting data from xml file. The xml data look like as
AC StartTime="1227858839" ID="88" ETime="1227858837" DSTFlag="false" Type="2" Duration="303" />
<AS StartTime="1227858849" SigPairs="119 40 98 15 100 32 128 18 131 23 70 39 123 20 120 27 100 17 136 12... (3 Replies)
I want to extract the last rows of a data file, similar to that one below:
C1 xxx
C2 rrr
C3 ttt
....
Cn-1 hhh
Cn bbb
C1 yyy
C2 sss
C3 uuu
...
Cn-1 iii
Cn ccc
...
I just want to extract the final rows between C1 and Cn at each data file. n is not a constant,... (2 Replies)
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)
Hi unix Gurus,
I am really new to Unix Scripting. Please help me to create a shell script which reads the xml file and from that i need to fetch a particular information.
For example
<SOURCE BUSINESSNAME ="" DATABASETYPE ="Teradata" DBDNAME ="DWPROD3" DESCRIPTION ="" NAME... (2 Replies)
Hi evry1,
This is my 1st post in this forum.Pls help me
I want to extract some data froma xml file which has 2000 lines using shell scripting. Actually my xml file has some "audio and video codes" which i need to arrange in a column wise format after extracting it using shell scripting.I... (4 Replies)
Hi ,
I have input file as XML. following are input data
#complex.xml
Code:
<?xml version="1.0" encoding="UTF-8"?><TEST_doc xmlns="http://www.w3.org/2001/XMLSchema-instance"> <ENTRY uid="123456"> <protein> <name>PROT001</name> <organism>Human</organism> ... (1 Reply)
Hi
I have xml file with multiple records and would like to extract records from xml with specific condition if specific tag is present extract entire row otherwise skip .
<logentry revision="21510">
<author>mantest</author>
<date>2015-02-27</date>
<QC_ID>334566</QC_ID>... (12 Replies)
Hi everyone,
So i'm struggling with an xml (log file) where we get information about some devices, so the logfile is filled with multiple "blocks" like that.
Based on the <devId> i want to extract this part of the xml file. If possible I want it to have an script for this, cause we'll use... (5 Replies)
Discussion started by: Pouky
5 Replies
LEARN ABOUT SUNOS
scrollkeeper-extract
scrollkeeper-devel(1) User Commands scrollkeeper-devel(1)NAME
scrollkeeper-devel, scrollkeeper-extract, scrollkeeper-gen-seriesid, scrollkeeper-preinstall - utilities for working with OMF documents and
the scrollkeeper database
SYNOPSIS
scrollkeeper-extract file stylesheet output [stylesheet output...]
scrollkeeper-gen-seriesid
scrollkeeper-preinstall docfile omf-file1 omf-file2
DESCRIPTION
scrollkeeper-extract is used internally by scrollkeeper to convert DocBook/SGML files to Docbook/XML files if necessary, and to apply a
number of transformations to the XML file to extract information from the XML file.
scrollkeeper-gen-seriesid generates a globally unique series ID for an OMF file.
scrollkeeper-preinstall reads omf_file1, changes the URL attribute of the identifier tag to doc_file and writes the output to omf_file2.
scrollkeeper-preinstall can be used during the document installation process to point OMF files to the correct location on the target
machine before registration in the scrollkeeper database.
OPTIONS
None.
OPERANDS
The following operands are supported:
docfile Specifies the file path to the document that omf-file1 describes.
file Specifies the XML file that is to be used as input for XSLT transformations.
omf-file1 Specifies the OMF file that contains metadata for docfile.
omf-file2 Specifies the file created by scrollkeeper-preinstall, which contains the same data as omf-file1 except that the URL
attribute of the identifier tag is changed to docfile.
output Specifies the file that contains the result when the preceding stylesheet has been applied to file.
stylesheet Specifies an XSLT transformation to apply.
EXAMPLES
Example 1: Creating a New scrollkeeper Series ID
example% scrollkeeper-gen-seriesid
Example 2: Extracting a TOC From a Document
example% scrollkeeper-extract /path/to/xml/file.xml /usr/share/scrollkeeper/stylesheets/toc.xsl /path/to/toc.xml
EXIT STATUS
The following exit values are returned:
0 Application exited successfully
>0 Application exited with failure
FILES
The following files are used by this application:
/usr/bin/scrollkeeper-extract
The command-line executable for the scrollkeeper-extract application.
/usr/bin/scrollkeeper-gen-seriesid
The command-line executable for the scrollkeeper-gen-seriesid application.
/usr/bin/scrollkeeper-preinstall
The command-line executable for the scrollkeeper-preinstall application.
ATTRIBUTES
See attributes(5) for descriptions of the following attributes:
+-----------------------------+-----------------------------+
| ATTRIBUTE TYPE | ATTRIBUTE VALUE |
+-----------------------------+-----------------------------+
|Availability |SUNWgnome-libs-devel |
+-----------------------------+-----------------------------+
|Interface stability |Evolving |
+-----------------------------+-----------------------------+
SEE ALSO scrollkeeper(1)NOTES
Written by Sander Vesik, Sun Microsystems Inc., 2003.
SunOS 5.10 01 Apr 2003 scrollkeeper-devel(1)