Extract value from XML Post: 302587585

Sponsored Content

Top Forums Shell Programming and Scripting Extract value from XML Post 302587585 by manas_ranjan on Thursday 5th of January 2012 09:41:48 AM

01-05-2012

Registered User

Extract value from XML

I have a file like below

Code:

<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"><soap:Body><ns2:executeMDXResponse xmlns:ns2="http://webservices.quartetfs.com"><aggregates><axes><axis><name>ROWS</name><positions><position><members><member><depth>0</depth><dimensionName>AsOfDate</dimensionName><displayName>AllMember</displayName><levelName>ALL</levelName><path><items><item>AllMember</item></items></path></member></members></position><position><members><member><depth>1</depth><dimensionName>AsOfDate</dimensionName><displayName>04-01-2012</displayName><levelName>AsOfDate</levelName><path><items><item>AllMember</item><item>04-01-2012</item></items></path></member></members></position><position><members><member><depth>1</depth><dimensionName>AsOfDate</dimensionName><displayName>20-12-2011</displayName><levelName>AsOfDate</levelName><path><items><item>AllMember</item><item>20-12-2011</item></items></path></member></members></position><position><members><member><depth>1</depth><dimensionName>AsOfDate</dimensionName><displayName>12-12-2011</displayName><levelName>AsOfDate</levelName><path><items><item>AllMember</item><item>12-12-2011</item></items></path></member></members></position><position><members><member><depth>1</depth><dimensionName>AsOfDate</dimensionName><displayName>09-12-2011</displayName><levelName>AsOfDate</levelName><path><items><item>AllMember</item><item>09-12-2011</item></items></path></member></members></position></positions></axis></axes><cells><cell><formattedValue>3840769</formattedValue><ordinal>0</ordinal><value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:long">3840769</value></cell><cell><formattedValue>444930</formattedValue><ordinal>1</ordinal><value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:long">444930</value></cell><cell><formattedValue>1136654</formattedValue><ordinal>2</ordinal><value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:long">1136654</value></cell><cell><formattedValue>1081680</formattedValue><ordinal>3</ordinal><value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:long">1081680</value></cell><cell><formattedValue>1177505</formattedValue><ordinal>4</ordinal><value xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:long">1177505</value></cell></cells><slicerAxis><name>SlicerAxis</name><positions><position><members><member><depth>0</depth><dimensionName>Measures</dimensionName><displayName>contributors.COUNT</displayName><levelName>Measures</levelName><path><items><item>contributors.COUNT</item></items></path></member></members></position></positions></slicerAxis></aggregates></ns2:executeMDXResponse></soap:Body></soap:Envelope>

not in properly aligned and everything in one line. So If I try to serach by grep or sed for a particular tag and value in between them, returns whole file ?
can anyone how can I search it?

I need to search date between displayName tag?

manas_ranjan

View Public Profile for manas_ranjan

Find all posts by manas_ranjan

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 extract XML value

I have the following string: <min-pool-size>2</min-pool-size> When I pipe the string into the following code I am expcting for it to return just the value "2", but its just reurning the whole string. Why?? sed -n '/<min-pool-size>/,/<\/min-pool-size>/p' Outputting:...

3. Shell Programming and Scripting

Extract xml data

Hi all, I have the following xml file : <xmlhead><xmlelement1>element1value</xmlelement1>\0a<xmlelement2>jjasd</xmlelement2>...</xmlhead> As you can see there are no lines or spaces seperating the elements, just the character \0a. How can i find and print the values of a specific element?...

4. Shell Programming and Scripting

XML data extract

Hi all, I have the following xml document : <HEADER><El1>asdf</El1> <El2>3</El2> <El3>asad</El3> <El4>asasdf</El4> <El5>asdf</El5> <El6>asdf</El6> <El7>asdf</El7> <El8>A</El8> <El9>0</El9> <El10>75291028141917</El10> <El11>asdf</El11> <El12>sdf</El12> <El13>er</El13> <El14><El15>asdf...

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

6. Shell Programming and Scripting

xml extract problem

I have looked at other responses and never was able to modify to work. data is: <?xml version="1.0"?> <note version="0.3" xmlns:link="http://beatniksoftware.com/tomboy/link" xmlns:size="http://beatniksoftware.com/tomboy/size" xmlns="http://beatniksoftware.com/tomboy"><title>recoll</title><text...

7. Shell Programming and Scripting

Extract string from XML

Hi, I wish to grep for the first instance of <listen-address> value between the first <server></server> tag in an xml file. Sample xml: ......... <timeout-seconds>1500</timeout-seconds> </jta> <server> <name>Adminserver_DEV</name> ...

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