Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Extract values from xml file script
Top Forums Shell Programming and Scripting Extract values from xml file script Post 303019538 by Chubler_XL on Sunday 1st of July 2018 06:11:49 PM
Old 07-01-2018
This appears to work OK for you sample input:

Code:
awk -F"<|>" '
BEGIN{print "ProjectName|NameID|STX-STY|PRX-PRY|OD-ODF|ODRangeStart|ODRangeStop"}
/ProjectName/{printf "%s",$3}
/NameID/{id=$3}
/<STX>/{stx=$3}
/<STY>/{sty=$3}
/<PRX>/{prx=$3}
/<PRY>/{pry=$3}
/<OD>/ {od=$3}
/ODF>/{odf=$3}
/ODRangeStart/{rngStart=$3}
/ODRangeStop/ {rngStop=$3}
/<.ValueRange/ {
printf "|%s|%s|%s|%s|%s|%s\n",id,stx?stx"-"sty:"",prx?prx"-"pry:"",od?od"-"odf:"",rngStart,rngStop
id=stx=sty=prx=pry=od=odf=rngStart=rngStop=""
}
'

 

9 More Discussions You Might Find Interesting

1. 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>... (5 Replies)
Discussion started by: yajaykumar
5 Replies

2. Shell Programming and Scripting

Extract XML Element Values

I have a rather large file with XML-style content. Each line contains one full XML entry. For example: 1:<Message><DNIS>1234</DNIS><UCID>3456</UCID><TransferGroup>XYZXYZ</TransferGroup></Message> 2:<Message><DNIS>9999</DNIS><UCID>2584</UCID><TransferGroup>ABCABC</TransferGroup></Message>... (1 Reply)
Discussion started by: sharpi03
1 Replies

3. Shell Programming and Scripting

KSH Script to Get the <TAG Values> from an XML file

Hi All, I am new to Unix I need a KSH script to get the values from XML file to write to a temp file. Like the requirement is from the below TAG <MAPPING DESCRIPTION ="Test Mapping" ISVALID ="YES" NAME ="m_test_xml" OBJECTVERSION ="1" VERSIONNUMBER ="1"> I need the MAPPING DESCRIPTION... (3 Replies)
Discussion started by: perlamohan
3 Replies

4. Shell Programming and Scripting

Perl script to extract 'ID' From XML File

File1.xml <?xml version.........> - <abcd:abcd_list version="1" www.john_uncle's_server.com" xmlns: - <device id="100"> <firmware>12.4(3d)</firmware> <location id="500">Sitting Room</location> </device> - <device id="101"> <firmware>12.4(3d)</firmware> <location id="501">Class... (1 Reply)
Discussion started by: sureshcisco
1 Replies

5. Shell Programming and Scripting

Extract values from an XML File

Hi, I need to capture all the attributes with delete next to it. The source XML file is attached. The output should contain something like this below: Attributes = legacyExchangeDN Action = Delete Username = Hero Joker Loginid = joker09 OU =... (4 Replies)
Discussion started by: prvnrk
4 Replies

6. Shell Programming and Scripting

Get multiple values from an xml file using one of the following commands or together awk/perl/script

Hello, I have a requirement to extract the value from multiple xml node and print out the values to new file to compare. Would be done using either awk/perl or some unix script. For example sample input file: ..... ..... <factories xmi:type="resources.jdbc:DataSource"... (2 Replies)
Discussion started by: slbmind
2 Replies

7. Shell Programming and Scripting

Passing values to an XML file from shell script

:wall: Hi, I have an XML file with 5 tags. I need to pass values to the XML file from a shell script that will replace values in 2 of the tags. I cannot hardcode the tag values in XML and use replace command in script as the values are likely to change. Please help !!!!!!!!!!! (2 Replies)
Discussion started by: Monalisaa
2 Replies

8. UNIX for Dummies Questions & Answers

Reading XML file and print the values in the text file using Linux shell script

hi guys, i want help... Reding XML file and print the values into the text file using linux shell script file as per below xml file <sequence> <Filename>aldorzum.doc</Filename> <DivisionCode>US</DivisionCode> <ContentType>Template</ContentType> <ProductCode>VIMZIM</ProductCode> </sequence>... (1 Reply)
Discussion started by: sravanreddy
1 Replies

9. Shell Programming and Scripting

How to extract xml attribute values using awk inline.?

I am trying to extract specific XML attribute values for search pattern <factories.*baseQueueName' from resources.xml. my scripts works ok,, but to extract 3 values this code does echo $line three times, it could be 'n' times. How can I use awk to extract matching pattern values in-line or... (11 Replies)
Discussion started by: kchinnam
11 Replies

LEARN ABOUT SUSE

ooconvert

ooconvert(1)							   User Commands						      ooconvert(1)

Name
       ooconvert - Commandline Document Converter Using OpenOffice.org

SYNOPSIS

       ooconvert [--help] [--force]  input output

DESCRIPTION

       This  tool  converts documents between various formats on the commandline.  It uses OpenOffice.org that guarantees the quality of available
       import and export filters.

       This tool tries to start OpenOffice.org in the server mode on backgroud.  It does not work if the OpenOffice.org  application  has  already
       been running. Also it slows down the conversion a lot. We hope to reduce these limitations in the further versions.

OPTIONS

       input  Input file. The filename suffix must be one of the currently supported file formats, see below.

       output Output  file. The filename suffix defines the output file format. It must be one from the table below. An existing file can be over-
	      written by the --force option.

       --help Print help and exit.

       --force
	      Force an already existing output file to be replaced.

SUPPORTED FILE FORMATS

       The current version of this tool does not read the list of available input and output filters directly from  OpenOffice.org.  The  list	of
       supported file formats is hardcoded and thus limited to:

       doc    Microsoft Word 97/2000/XP

       docx   MS Word 2007 XML

       dot    Microsoft Word 97/2000/XP Template

       dotx   MS Word 2007 XML Template

       html   HyperText Markup Language (Web Page)

       odt    ODF Text Document

       ods    ODF Spreadsheet

       odp    ODF Presentation

       ott    ODF Text Document Template

       ots    ODF Spreadsheet Template

       otp    ODF Presentation Template

       pdf    Portable Document Format

       ppt    Microsoft PowerPoint 97/2000/XP

       pptx   Microsoft PowerPoint 2007 XML

       pot    Microsoft PowerPoint 97/2000/XP Template

       potx   Microsoft PowerPoint 2007 XML Template

       rtf    Rich Text Format

       stc    OpenOffice.org 1.0 Spreadsheet Template

       sti    OpenOffice.org 1.0 Presentation Template

       stw    OpenOffice.org 1.0 Text Document Template

       sxc    OpenOffice.org 1.0 Spreadsheet

       sxi    OpenOffice.org 1.0 Presentation

       sxw    OpenOffice.org 1.0 Text Document

       swf    Macromedia Flash

       txt    Plain Text

       xls    Microsoft Excel 97/2000/XP

       xlsx   Microsoft Excel 2007 XML

       xlt    Microsoft Excel 97/2000/XP Template

       xltx   Microsoft Excel 2007 XML Template

TROUBLESHOOTING PROBLEMS

       See http://en.opensuse.org/Bugs:OOo for more details about how to report bugs in OpenOffice.org.

AUTHOR

       This manual page was created by Petr Mladek <petr.mladek@novell.com>.

OpenOffice.org Converter					    2009-02-09							      ooconvert(1)
All times are GMT -4. The time now is 08:59 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy