Sponsored Content
Top Forums Shell Programming and Scripting Extract strings within XML file between different delimiters Post 302602967 by chihung on Tuesday 28th of February 2012 07:52:29 PM
Old 02-28-2012
It is safer to use an XML tool to extract the information. Just install perl-XML-XPath
Code:
#!/usr/bin/perl

use XML::XPath;

$filename = 'stdin';
$xpath = XML::XPath->new(ioref => \*STDIN);
$nodes = $xpath->find('//*[@oa_var]');
foreach my $node ($nodes->get_nodelist) {
        print $node->getAttribute('oa_var'), " ";
        $text=$node->getFirstChild();
        if ( $text ) {
                print $text->getData();
        }
        print "\n";
}

 

10 More Discussions You Might Find Interesting

1. Solaris

To extract everything between two delimiters

My input file looks like " @$SCRIPT/atp_asrmt_adj.sql $SCRIPT/dba2000.scr -s / @$SCRIPT/cim1005w.pls $SCRIPT/dba2000.scr -s / @$SCRIPT/cim1006w.pls start $SCRIPT/cim1020d.sql;^M spool $DATA/cim1021m.sql @$DATA/cim1021m.sql ! rm $DATA/cim1021m.sql spool $DATA/cim1021m.sql... (1 Reply)
Discussion started by: dowsed4u8
1 Replies

2. Programming

c program to extract text between two delimiters from some text file

needa c program to extract text between two delimiters from some text file. and then storing them in to diffrent variables ? text file like 0: abc.txt ========= aaaaaa|11111111|sssssssssss|333333|ddddddddd|34343454564|asass aaaaaa|11111111|sssssssssss|333333|ddddddddd|34343454564|asass... (7 Replies)
Discussion started by: kukretiabhi13
7 Replies

3. UNIX for Dummies Questions & Answers

Hiding database connection strings from xml file

Hi , I have a configuration file with the following structure: <CONFIG> <DEFAULTS operator="oraread"> <PROPERTY name="hostname" value="myhostname"/> <PROPERTY name="port" value="12343"/> <PROPERTY name="dbname" value="dbname"/> <PROPERTY... (0 Replies)
Discussion started by: neeto
0 Replies

4. Shell Programming and Scripting

Extract strings from file - Help

Hi, I have a file say with following lines (the lines could start from any column and there can be many many create statements in the file) create table table1....table definition... insert into table1 values..... create or replace view view1....view definition.... What i want is to... (2 Replies)
Discussion started by: whoami191
2 Replies

5. Shell Programming and Scripting

Extract two strings from a file and create a new file with these strings

I have the following lines in a log file. It would be great if some one can help me to create a new file with the just entries in the below format. 66.150.161.195 HPSAC=Z05 66.150.161.196 HPSAC=A05 That is just extract the IP address and the string DPSAC=its value 66.150.161.195 -... (1 Reply)
Discussion started by: Tuxidow
1 Replies

6. Shell Programming and Scripting

Extract a particular xml only from an xml jar file

Hi..need help on how to extract a particular xml file only from an xml jar file... thanks! (2 Replies)
Discussion started by: qwerty000
2 Replies

7. Shell Programming and Scripting

Replace the .txt file between two strings in XML file

Hi i am having XML file with many number of lines,I need to replace between two strings with .txt file using awk. For ex <PersonInfoShipTo ------------------------------ /> My requirement is to replace the content between <PersonInfoShipTo ------------------------------ /> help me. Thanks... (9 Replies)
Discussion started by: Padmanabhan
9 Replies

8. Shell Programming and Scripting

Extract strings from XML files and create a new XML

Hello everybody, I have a double mission with some XML files, which is pretty challenging for my actual beginner UNIX knowledge. I need to extract some strings from multiple XML files and create a new XML file with the searched strings.. The original XML files contain the source code for... (12 Replies)
Discussion started by: milano.churchil
12 Replies

9. Shell Programming and Scripting

Extract a value from an xml file

I have this XML file format and all in one line: Fri Dec 23 00:14:52 2016 Logged Message:689|<?xml version="1.0" encoding="UTF-8"?><PORT_RESPONSE><HEADER><ORIGINATOR>XMG</ORIGINATOR><DESTINAT... (16 Replies)
Discussion started by: mrn6430
16 Replies

10. Shell Programming and Scripting

--Parsing out strings for repeating delimiters for everyline

Hello: I have some text output, on SunOS 5.11 platform using KSH: I am trying to parse out each string within the () for each line. I tried, as example: perl -lanF"" -e 'print "$F $F $F $F $F $F"' But for some reason, the output gets all garbled after the the first fields.... (8 Replies)
Discussion started by: gilgamesh
8 Replies
Template::Plugin::XML::XPath(3pm)			User Contributed Perl Documentation			 Template::Plugin::XML::XPath(3pm)

NAME
Template::Plugin::XML::XPath - Plugin interface to XML::XPath SYNOPSIS
# load plugin and specify XML file to parse [% USE xpath = XML.XPath(xmlfile) %] [% USE xpath = XML.XPath(file => xmlfile) %] [% USE xpath = XML.XPath(filename => xmlfile) %] # load plugin and specify XML text to parse [% USE xpath = XML.XPath(xmltext) %] [% USE xpath = XML.XPath(xml => xmltext) %] [% USE xpath = XML.XPath(text => xmltext) %] # then call any XPath methods (see XML::XPath docs) [% FOREACH page = xpath.findnodes('/html/body/page') %] [% page.getAttribute('title') %] [% END %] # define VIEW to present node(s) [% VIEW repview notfound='xmlstring' %] # handler block for a <report>...</report> element [% BLOCK report %] [% item.content(view) %] [% END %] # handler block for a <section title="...">...</section> element [% BLOCK section %] <h1>[% item.getAttribute('title') | html %]</h1> [% item.content(view) %] [% END %] # default template block passes tags through and renders # out the children recursivly [% BLOCK xmlstring; item.starttag; item.content(view); item.endtag; END %] # block to generate simple text [% BLOCK text; item | html; END %] [% END %] # now present node (and children) via view [% repview.print(page) %] # or print node content via view [% page.content(repview) %] DESCRIPTION
This is a Template Toolkit plugin interfacing to the XML::XPath module. All methods implemented by the XML::XPath modules are available. In addition, the XML::XPath::Node::Element module implements present($view) and content($view) methods method for seamless integration with Template Toolkit VIEWs. The XML::XPath::Node::Text module is also adorned with a present($view) method which presents itself via the view using the 'text' template. To aid the reconstruction of XML, methods starttag and endtag are added to XML::XPath::Node::Element which return the start and end tag for that element. This means that you can easily do: [% item.starttag %][% item.content(view) %][% item.endtag %] To render out the start tag, followed by the content rendered in the view "view", followed by the end tag. AUTHORS
This plugin module was written by Andy Wardley. The XML::XPath module is by Matt Sergeant. COPYRIGHT
Copyright (C) 1996-2006 Andy Wardley. All Rights Reserved. This module is free software; you can redistribute it and/or modify it under the same terms as Perl itself. SEE ALSO
Template::Plugin, XML::XPath, XML::Parser perl v5.8.8 2008-03-01 Template::Plugin::XML::XPath(3pm)
All times are GMT -4. The time now is 12:17 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy