SED extract XML value Post: 302348095

Sponsored Content

Top Forums Shell Programming and Scripting SED extract XML value Post 302348095 by Franklin52 on Thursday 27th of August 2009 09:38:03 AM

08-27-2009

Registered User

The solutions work fine for me. This is what I get:

Code:

$ cat file
    <JDBCDataSource JNDIName="jdbc/rDB"
        Name="" PoolName="Othername"   Targets="myserver"/>
    <JDBCConnectionPool CapacityIncrement="2"
        DriverName="net.sourceforge.jtds.jdbc.Driver"
        InitialCapacity="4" MaxCapacity="20" Name="Othername"
        PasswordEncrypted="" Properties="user="
        Targets="myserver" TestConnectionsOnRelease="false" URL=""/>
    <JDBCDataSource JNDIName="jdbc/FirstDataBankDB" Name="fdbDataSource"
        PoolName="Othernamel" Targets="myserver"/>

<JDBCConnectionPool CapacityIncrement="5"
        DriverName="oracle.jdbc.driver.OracleDriver" InitialCapacity="5"
        MaxCapacity="35" Name="Othername"
        PasswordEncrypted=""
        PreparedStatementCacheSize="25"
        Properties=;dll=ocijdbc8;protocol=thin"
        RefreshMinutes="10" Targets="myserver"
        TestConnectionsOnRelease="false" TestConnectionsOnReserve="true"
        TestTableName="dual" URL=""/>

    <JDBCDataSource JNDIName="" 
        Name="ThisName"
        PoolName="l" RowPrefetchEnabled="true"
        RowPrefetchSize="100" Targets="myserver"
        CapacityIncrement="2"
        DriverName="net.sourceforge.jtds.jdbc.Driver"
        InitialCapacity="4" MaxCapacity="20" Name=""
        PasswordEncrypted="" Properties="user"
        Targets="myserver" TestConnectionsOnRelease="false" URL=""/>

    <JDBCDataSource JNDIName="jdbc/rDB"
        Name="" PoolName="Othername"   Targets="myserver"/>
    <JDBCConnectionPool CapacityIncrement="2"
        DriverName="net.sourceforge.jtds.jdbc.Driver"
        InitialCapacity="4" MaxCapacity="20" Name="Othername"
        PasswordEncrypted="" Properties="user="
        Targets="myserver" TestConnectionsOnRelease="false" URL=""/>
    <JDBCDataSource JNDIName="jdbc/FirstDataBankDB" Name="fdbDataSource"
        PoolName="Othernamel" Targets="myserver"/>
</Domain>
$
$ tr '\n' '_' < file | tr '>' '\n'|sed '/Name="ThisName"/d'| tr '\n' '>'| tr '_' '\n'
    <JDBCDataSource JNDIName="jdbc/rDB"
        Name="" PoolName="Othername"   Targets="myserver"/>
    <JDBCConnectionPool CapacityIncrement="2"
        DriverName="net.sourceforge.jtds.jdbc.Driver"
        InitialCapacity="4" MaxCapacity="20" Name="Othername"
        PasswordEncrypted="" Properties="user="
        Targets="myserver" TestConnectionsOnRelease="false" URL=""/>
    <JDBCDataSource JNDIName="jdbc/FirstDataBankDB" Name="fdbDataSource"
        PoolName="Othernamel" Targets="myserver"/>

<JDBCConnectionPool CapacityIncrement="5"
        DriverName="oracle.jdbc.driver.OracleDriver" InitialCapacity="5"
        MaxCapacity="35" Name="Othername"
        PasswordEncrypted=""
        PreparedStatementCacheSize="25"
        Properties=;dll=ocijdbc8;protocol=thin"
        RefreshMinutes="10" Targets="myserver"
        TestConnectionsOnRelease="false" TestConnectionsOnReserve="true"
        TestTableName="dual" URL=""/>

    <JDBCDataSource JNDIName="jdbc/rDB"
        Name="" PoolName="Othername"   Targets="myserver"/>
    <JDBCConnectionPool CapacityIncrement="2"
        DriverName="net.sourceforge.jtds.jdbc.Driver"
        InitialCapacity="4" MaxCapacity="20" Name="Othername"
        PasswordEncrypted="" Properties="user="
        Targets="myserver" TestConnectionsOnRelease="false" URL=""/>
    <JDBCDataSource JNDIName="jdbc/FirstDataBankDB" Name="fdbDataSource"
        PoolName="Othernamel" Targets="myserver"/>
$
$
$ awk '/ThisName/{next}1' ORS="\n\n" RS=  FS="\n" file
    <JDBCDataSource JNDIName="jdbc/rDB"
        Name="" PoolName="Othername"   Targets="myserver"/>
    <JDBCConnectionPool CapacityIncrement="2"
        DriverName="net.sourceforge.jtds.jdbc.Driver"
        InitialCapacity="4" MaxCapacity="20" Name="Othername"
        PasswordEncrypted="" Properties="user="
        Targets="myserver" TestConnectionsOnRelease="false" URL=""/>
    <JDBCDataSource JNDIName="jdbc/FirstDataBankDB" Name="fdbDataSource"
        PoolName="Othernamel" Targets="myserver"/>

<JDBCConnectionPool CapacityIncrement="5"
        DriverName="oracle.jdbc.driver.OracleDriver" InitialCapacity="5"
        MaxCapacity="35" Name="Othername"
        PasswordEncrypted=""
        PreparedStatementCacheSize="25"
        Properties=;dll=ocijdbc8;protocol=thin"
        RefreshMinutes="10" Targets="myserver"
        TestConnectionsOnRelease="false" TestConnectionsOnReserve="true"
        TestTableName="dual" URL=""/>

    <JDBCDataSource JNDIName="jdbc/rDB"
        Name="" PoolName="Othername"   Targets="myserver"/>
    <JDBCConnectionPool CapacityIncrement="2"
        DriverName="net.sourceforge.jtds.jdbc.Driver"
        InitialCapacity="4" MaxCapacity="20" Name="Othername"
        PasswordEncrypted="" Properties="user="
        Targets="myserver" TestConnectionsOnRelease="false" URL=""/>
    <JDBCDataSource JNDIName="jdbc/FirstDataBankDB" Name="fdbDataSource"
        PoolName="Othernamel" Targets="myserver"/>
</Domain>
$
$

Am I missing something?

Franklin52

View Public Profile for Franklin52

Find all posts by Franklin52

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

� simerian � XML Extract

The script following in this thread allows XML data to be located and extracted in a variety of forms from an XML data stream. Using this utility, it is possible to extract all manner of XML subsets and allow data to be post inserted into the "original" XML at any logical point. The pipe is...

2. Shell Programming and Scripting

sed or awk to extract data from Xml file

Hi, I want to get data from Xml file by using sed or awk command. I want to get the following result : mon titre 1;Createur1;Dossier1 mon titre 1;Createur1;Dossier1 and save it in cvs file (fichier.cvs). FROM this Xml file (test.xml): <playlist version="1"> <trackList> <track>...

3. Shell Programming and Scripting

Using SED/AWK to extract xml at end of file

Hello everyone, Firstly i do not require alot of help.. i am right at the end of finishing my scipt but cannot find a solution to the last part. What i need to do is, prompt the user for a file to work with, which i have done. promt the user for an output file - which is done. #!/bin/bash...

4. Shell Programming and Scripting

sed extract from xml

I have an xml file that generally looks like this: "<row><dnorpattern>02788920</dnorpattern><description/></row><row><dnorpattern>\+ 44146322XXXX</dnorpattern><description/></row><row><dnorpattern>40XXX</dnorpattern><description/></row><row><dnorpattern>11</dn...

5. Shell Programming and Scripting

Extract value from XML

I have a file like below <soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"><soap:Body><ns2:executeMDXResponse...

6. Shell Programming and Scripting

Extract Multivalue from XML

I have below attached xml file , how can I have my desired output as below. i/p file <soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"><soap:Body><ns2:executeMDXResponse...

7. Shell Programming and Scripting

sed - extract text from xml file

hi, please help, i have an xml file, e.g: ... <tag> test text asdas="${abc}" xvxvbs:asdas${222}sdad asasa="${aa_bb_22}" </tag> ... i want to extract all "${...}", e.g: ${abc} ${222} ${aa_bb_22} thank you.

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

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

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