Extract Multivalue from XML

Shell Programming and Scripting
1

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 xmlns:ns2="http://webservices.fs.com"><aggregates><axes><axis><name>COLUMNS</name><positions><position><members><member><depth>1</depth><dimensionName>AsOfDate</dimensionName><displayName>05-01-2012</displayName><levelName>AsOfDate</levelName><path><items><item>AllMember</item><item>05-01-2012</item></items></path></member><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></axis><axis><name>ROWS</name><positions><position><members><member><depth>1</depth><dimensionName>LCSBook</dimensionName><displayName>CBD</displayName><levelName>LCSBook</levelName><path><items><item>AllMember</item><item>CBD</item></items></path></member><member><depth>1</depth><dimensionName>Filename</dimensionName><displayName>TRISS_FXCB.csv</displayName><levelName>Filename</levelName><path><items><item>AllMember</item><item>TRISS_FXCB.csv</item></items></path></member></members></position><position><members><member><depth>1</depth><dimensionName>LCSBook</dimensionName><displayName>CBD</displayName><levelName>LCSBook</levelName><path><items><item>AllMember</item><item>CBD</item></items></path></member><member><depth>1</depth><dimensionName>Filename</dimensionName><displayName>hvar_RGRPD_10D_HVBRUCD_KGR_PROD.xml</displayName><levelName>Filename</levelName><path><items><item>AllMember</item><item>hvar_RGRPD_10D_HVBRUCD_KGR_PROD.xml</item></items></path></member></members></position><position><members><member><depth>1</depth><dimensionName>LCSBook</dimensionName><displayName>CBD</displayName><levelName>LCSBook</levelName><path><items><item>AllMember</item><item>CBD</item></items></path></member><member><depth>1</depth><dimensionName>Filename</dimensionName><displayName>hvar_RGRPD_10D_SV_HVBRUCD_KGR_PROD.xml</displayName><levelName>Filename</levelName><path><items><item>AllMember</item><item>hvar_RGRPD_10D_SV_HVBRUCD_KGR_PROD.xml</item></items></path></member></members></position><position><members><member><depth>1</depth><dimensionName>LCSBook</dimensionName><displayName>CBD</displayName><levelName>LCSBook</levelName><path><items><item>AllMember</item><item>CBD</item></items></path></member><member><depth>1</depth><dimensionName>Filename</dimensionName><displayName>hvar_RGRPD_1D_HVBRUCD_KGR_PROD.xml</displayName><levelName>Filename</levelName><path><items><item>AllMember</item><item>hvar_RGRPD_1D_HVBRUCD_KGR_PROD.xml</item></items></path></member></members></position></positions></axis></axes><cells><cell><formattedValue>17</formattedValue><ordinal>0</ordinal><value xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xs="http://www.w3.org/2001/XMLSchema" xsi:type="xs:long">17</value></cell><cell><formattedValue>75</formattedValue><ordinal>1</ordinal><value xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xs="http://www.w3.org/2001/XMLSchema" xsi:type="xs:long">75</value></cell><cell><formattedValue>75</formattedValue><ordinal>2</ordinal><value xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xs="http://www.w3.org/2001/XMLSchema" xsi:type="xs:long">75</value></cell><cell><formattedValue>75</formattedValue><ordinal>3</ordinal><value xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xs="http://www.w3.org/2001/XMLSchema" xsi:type="xs:long">75</value></cell></cells></aggregates></ns2:executeMDXResponse></soap:Body></soap:Envelope>

desired o/p

		                                            5/1/2012
		                                 contributors.COUNT
CBD	TRISS_FXCB.csv	                                      17
	hvar_RGRPD_10D_HVBRUCD_KGR_PROD.xml	75
	hvar_RGRPD_10D_SV_HVBRUCD_KGR_PROD.xml	75
	hvar_RGRPD_1D_HVBRUCD_KGR_PROD.xml	75
2

use an XML parser in a language like Python, Perl, etc...

3

thanks frank but I'm looking for some idea in linux itself.
Hope you have something to share.

4

Is there any reason you don't want to use Perl or Python?
Although it may not be to your liking, you got an accurate and appropriate answer from frank_rizzo. You could roll your own XML parser, but if you can't/don't want to reinvent the wheel, using perl's or pythons XML libs is the easiest way. Just google around, there are a bunch of tutorials out there, and it seems like it may be useful for you, if you think you will encounter this kind of problem more than once.

5

I don't have perl and python in my system.
Thats the whole reason for it.