Extract the specific tags in a XML file Post: 303004925

Sponsored Content

Top Forums Shell Programming and Scripting Extract the specific tags in a XML file Post 303004925 by Siv51427882 on Wednesday 11th of October 2017 01:19:28 AM

10-11-2017

Registered User

Hello R.Singh&Yoda,

I have another problem here.
Kindly consider the below code,

Code:

 <jdbc-system-resource>
    <name>EDNLocalTxDataSource</name>
    <target>soa_server1</target>
    <descriptor-file-name>jdbc/EDNLocalTxDataSource-jdbc.xml</descriptor-file-name>
  </jdbc-system-resource>
  <jdbc-system-resource>
    <name>SOALocalTxDataSource</name>
    <target>soa_server1</target>
    <descriptor-file-name>jdbc/SOALocalTxDataSource-jdbc.xml</descriptor-file-name>
  </jdbc-system-resource>
  <jdbc-system-resource>
    <name>mds-soa</name>
    <target>AdminServer,soa_server1</target>
    <descriptor-file-name>jdbc/mds-soa-jdbc.xml</descriptor-file-name>
  </jdbc-system-resource>
  <jdbc-system-resource>
    <name>aqjmsuserDataSource</name>
    <target>soa_server1</target>
    <descriptor-file-name>jdbc/aqjmsuserDataSource-1696-jdbc.xml</descriptor-file-name>
  </jdbc-system-resource>

IN the Above code, i have to avoid the <jdbc-system-resources> entries for which <name> contains "SOA" or "soa" or "EDN" or "mds" or "SDP" or "sdp"

for the above code, i would like to get an output like below.

Code:

  <jdbc-system-resource>
    <name>aqjmsuserDataSource</name>
    <target>soa_server1</target>
    <descriptor-file-name>jdbc/aqjmsuserDataSource-1696-jdbc.xml</descriptor-file-name>
  </jdbc-system-resource>
  <jdbc-system-resource>

BTW, Thanks for you kind help. your suggestions are lot for me.

Thanks,
Siva

Siv51427882

View Public Profile for Siv51427882

Find all posts by Siv51427882

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

extract specific data from xml format file.

Hi, I need to extract the start time value (bold, red font) under the '<LogEvent ID="Timer Start">' tag (black bold) from a file with the following pattern. There are other LogEventIDs listed in the file as well, making it harder for me to extract out the specific start time that I need. . ....

2. UNIX for Dummies Questions & Answers

Extract a specific number from an XML file based on the start and end tags

Hello People, I have the following contents in an XML file ........... ........... .......... ........... <Details = "Sample Details"> <Name>Bob</Name> <Age>34</Age> <Address>CA</Address> <ContactNumber>1234</ContactNumber> </Details> ........... ............. ..............

3. Shell Programming and Scripting

bash extract all occurences delimited from <name> and </name> tags from an xml file

I need to extract all text delimited from <name> and </name> tags from an xml file, but not only first occurence. I need to extract all occurences. I've tried with this command: awk -F"<name>|</name>" 'NF>2{print $2}' but it give only first occurence. How can i modify it?

4. Shell Programming and Scripting

How to add the multiple lines of xml tags before a particular xml tag in a file

Hi All, I'm stuck with adding multiple lines(irrespective of line number) to a file before a particular xml tag. Please help me. <A>testing_Location</A> <value>LA</value> <zone>US</zone> <B>Region</B> <value>Russia</value> <zone>Washington</zone> <C>Country</C>...

5. Shell Programming and Scripting

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. <ns1:root xmlns:ns1="http://example.com/config"> <ns1:interface>in1</ns1:interface> <ns1:operation attribute1="true" attribute2="abd"...

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!

7. Shell Programming and Scripting

Extract specific line in an html file starting and ending with specific pattern to a text file

Hi This is my first post and I'm just a beginner. So please be nice to me. I have a couple of html files where a pattern beginning with "http://www.site.com" and ending with "/resource.dat" is present on every 241st line. How do I extract this to a new text file? I have tried sed -n 241,241p...

8. Shell Programming and Scripting

Parse xml in shell script and extract records with specific condition

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

9. UNIX for Beginners Questions & Answers

How can we extract specific elements from XML?

Hi, I have a requirement to extract specific element value dynamically from XML message. Here is the sample message: <File> <List> <main> <dir>doc/store834/archive</dir> <count>5</count> </main> <main> <dir>doc/store834/extract</dir> <count>6</count> </main> <main> ...

10. UNIX for Beginners Questions & Answers

How to pull multiple XML tags from the same XML file in Shell.?

I'm searching for the names of a TV show in the XML file I've attached at the end of this post. What I'm trying to do now is pull out/list the data from each of the <SeriesName> tags throughout the document. Currently, I'm only able to get data the first instance of that XML field using the...

LEARN ABOUT SUNOS

list-jdbc-connection-pools

asadmin-list-jdbc-connection-pools(1AS) 			   User Commands			   asadmin-list-jdbc-connection-pools(1AS)

NAME

       asadmin-list-jdbc-connection-pools, list-jdbc-connection-pools - gets all the JDBC connection pools

SYNOPSIS

       list-jdbc-connection-pools  --user  admin_user  [--password  admin_password] [--host localhost] [--port 4848][ [--secure|-s] --passwordfile
       filename] [--terse=false] [--echo=false] [--interactive]

       Gets all the JDBC connection pools. This command is supported in remote mode only.

OPTIONS

       --user		       authorized domain application server administrative username.

       --password	       password to administer the domain application server.

       --host		       machine name where the domain application server is running.

       --port		       port number of the domain application server listening for administration requests.

       --secure 	       if true, uses SSL/TLS to communicate with the domain application server.

       --passwordfile	       file containing the domain application server password.

       --terse		       indicates that any output data must be very concise, typically avoiding human-friendly sentences and favoring well-
			       formatted data for consumption by a script.

       --echo		       setting to true will echo the command line statement on the standard output.

       --interactive	       prompts you for the required options that are not already specified.

       Example 1: Using list-jdbc-connection-pools

       asadmin> list-jdbc-connection-pools --user admin
       --password adminadmin --host fuyako --port 7070 server
       XA_connection_pool

       Where: XA_connection_pool is the JDBC connection listed.

EXIT STATUS

       0		       command executed successfully

       1		       error in executing the command

       asadmin-create-jdbc-connection-pool(1AS), asadmin-delete-jdbc-connection-pool(1)

J2EE 1.4 SDK							    March 2004				   asadmin-list-jdbc-connection-pools(1AS)

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

extract specific data from xml format file.

Discussion started by: 60doses

2. UNIX for Dummies Questions & Answers

Extract a specific number from an XML file based on the start and end tags

Discussion started by: sushant172

3. Shell Programming and Scripting

bash extract all occurences delimited from <name> and </name> tags from an xml file

Discussion started by: ingalex

4. Shell Programming and Scripting

How to add the multiple lines of xml tags before a particular xml tag in a file

Discussion started by: mjavalkar