Expected output:-
for each <jdbc-system-resource> tag in above code,
1) The script has to create a new file with a name of '<name>.properties'
2) And in that file, the script has to map parameters like below
target servers = the content of <target></target>
descriptor file name = the content of <descriptor-file-name></descriptor-file-name>
For this snippet, the expected output is like below
1) The script has create a new file called wlsbjmsrpDataSource.properties
2) In the wlsbjmsrpDataSource.properties file,
target servers = AdminServer,osb_server1
descriptor file name = jdbc/wlsbjmsrpDataSource-jdbc.xml
3) The script has to repeat the same for each and every <jdbc-system-resource>
I would like to request you to please open a NEW Thread for any new kind of questions because it may be confusing for people. Following may help you in same and let me know in case of any queries.
Code:
awk -v s1="target servers = " -v s2="descriptor file name = " -F"[><]" '
flag && /<\/jdbc-system-resource>/{
flag="";
print val1 ORS val2 > file;
close(file)
}
/<jdbc-system-resource>/{
flag=1;
next
}
flag && /<name>/{
file=$3".properties";
next
}
flag && /<target>/{
val1=s1 $3;
next
}
flag && /<descriptor-file-name>/ && flag{
val2=s2 $3;
next
}
' Input_file
Thanks,
R. Singh
This User Gave Thanks to RavinderSingh13 For This Post:
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... (9 Replies)
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> ... (3 Replies)
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>... (12 Replies)
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... (13 Replies)
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"... (2 Replies)
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>... (0 Replies)
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? (18 Replies)
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>
...........
.............
.............. (4 Replies)
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.
.
.... (7 Replies)
10-30-2017
