Parse xml in shell script and extract records with specific condition

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Extract Matched Records from XML

Hi All, I have a requirement to extract para in XML file on the basis of another list file having specific parameters. I will extract these para from XML and import in one scheduler tool. file2 <FOLDER DATACENTER="ControlMserver" VERSION="800" PLATFORM="UNIX" FOLDER_NAME="SH_AP_INT_B01"...

2. Shell Programming and Scripting

Extract top 20 records from sybase db in shell script

Hi, I am new to advanced scripting. I need to get top 20 records from database (Sybase) with a condition that all Char/varchar columns should have more than 4 characters. I need to do this via shell scripting, I have got half logic (on how to get varchar/char columns and stored it in a...

3. Shell Programming and Scripting

How to Parse the XML data along with the URL in Shell Script?

Hi, Can anybody help to solve this. I want to parse some xmldata along with the URL in the Shell. I'm calling the URL via the curl command Given below is my shell script file export...

4. Shell Programming and Scripting

Extract and parse XML data (statistic value) to csv

Hi All, I need to parse some statistic data from the "measInfo" -eg. 25250000 (as highlighted) and return the result into line by line, and erasing all other unnecessary info/tag. Thought of starting with grep "measInfoID="25250000" but this only returns 1 line. How do I get all the output...

5. Shell Programming and Scripting

Shell script (not Perl) to parse xml with awk

Hi, I have to make an script according to these: - I have couples of files like: xxxxxxxxxxxxx.csv xxxxxxxxxxxxx_desc.xml - every xml file has diferent fields, but keeps this format: ........ <defaultName>2011-02-25T16:43:43.582Z</defaultName> ...........

6. Shell Programming and Scripting

extract xml tag based on condition

Hi All, I have a large xml file of invoices. The file looks like below: <INVOICES> <INVOICE> <NAME>Customer A</NAME> <INVOICE_NO>1234</INVOICE_NO> </INVOICE> <INVOICE> <NAME>Customer A</NAME> <INVOICE_NO>2345</INVOICE_NO> </INVOICE> <INVOICE> <NAME>Customer A</NAME>...

7. Shell Programming and Scripting

Parse XML file in shell script

Hi Everybody, I have an XML file containing some data and i want to extract it, but the specific issue in my file is that the data is repeated some times like the following example : <section1> <subsection1> X=... Y=... Z=... <\subsection1> <subsection2> X=... Y=... Z=......

8. Shell Programming and Scripting

regex/shell script to Parse through XML Records

Hi All, I have been working on something that doesn't seem to have a clear regex solution and I just wanted to run it by everyone to see if I could get some insight into the method of solving this problem. I have a flat text file that contains billing records for users, however the records...

9. Shell Programming and Scripting

Help with shell script to extract data from XML file

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>...

10. Shell Programming and Scripting

Parse a string in XML file using shell script

Hi! I'm just new here and don't know much about shell scripting. I just want to ask for help in creating a shell script that will parse a string or value of the status in the xml file. Please sample xml file below. Can you please help me create a simple script to get the value of status? Also it...

LEARN ABOUT DEBIAN

scrollkeeper-devel

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)

Shell Programming and Scripting