The code worked perfectly. However now i have a new requirement . the value of a particular tag is dynamic . How do i incorporate pattern matchin for a variable in the same code.
my new xml is
Here the value June is obtained in the following way
the lookup file has entry
The value if var needs to be used to match against the config file. How do i use the shell variable in awk in this case.
Last edited by Franklin52; 04-10-2013 at 04:31 AM..
Reason: Please use code tags for data and code samples
Hi. Thanks for any help with this. I'm not new to programming but I am new to shell programming. I need a script that will
1. execute 'df -k' and return the volume names with specific text
2. surround each line of the above results in opening and closing xml tags
3. insert the results of step... (5 Replies)
I have an xml file:
<AutoData xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<Table1>
<Data1 10 </Data1>
<Data2 20 </Data2>
<Data3 40 </Data3>
<Table1>
</AutoData>
and I have to remove the portion xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" only.
I tried using sed... (10 Replies)
Hi All,
Good day
Here is my data:
<Journal>
<JournalCode>2</JournalCode>
<JournalType>L</JournalType>
<JournalEntry>SG</JournalEntry>
<JournalAmount>-0.05</JournalAmount>
</Journal>
Problem:
1) I need to query the above tags in xml. Which is from the header <Journal>... (4 Replies)
Hello,
I trying to extract text that is surrounded by xml-tags. I tried this
cat tst.xml | egrep "<SERVER>.*</SERVER>" |sed -e "s/<SERVER>\(.*\)<\/SERVER>/\1/"|tr "|" " "
which works perfect, if the start-tag and the end-tag are in the same line, e.g.:
<tag1>Hello Linux-Users</tag1>
... (5 Replies)
Hi All,
I have the following code in one of my xml file:
<com:parameter>
<com:name>secretKey</com:name>
<com:value>31XA874821172E89B00B1C</com:value>
</com:parameter>
<com:parameter>
<com:name>tryDisinfect</com:name>
<com:value>false</com:value>
</com:parameter>
<com:parameter>... (4 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 have a XML in which <Amt Ccy="EUR">3.1</Amt> tag repeats. This is under another tag <Main>. I need to sum all the values of <Amt Ccy=""> (Ccy may vary) coming under <Main> using awk and or sed command.
can some help?
Sample looks like below
<root>
<Main>
... (6 Replies)
I've got two different files and want to compare them.
File 1 :
HTML Code:
<response ticketId="944" type="getQueryResults"><status>COMPLETE</status><description>Query results fetched successfully</description><recordSet totalCount="1" type="sms_records"><record... (1 Reply)
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)