Parse XML File.

Shell Programming and Scripting
1

HI Guys

I have Below XML File :

  <xn:SubNetwork id="XYZ">
            <xn:SubNetwork id="C01">
                <xn:MeContext id="CO1">
                    <xn:ManagedElement id="1">
                        <un:RncFunction id="1">
                            <un:UtranCell id="NY431">
                                <un:attributes>
                                    <un:localCellId>65431</un:localCellId>
                                    <un:uarfcnUl>4159</un:uarfcnUl>
                                    <un:uraList></un:uraList>
                                </un:attributes>
				    <xn:VsDataContainer id="NY431">
                                    <xn:attributes>
                                    <xn:vsDataType>vsDataUtranCell</xn:vsDataType>
                                    <es:vsDataUtranCell>
                                    <es:maxTxPowerUl>24</es:maxTxPowerUl>
                                    <es:pwrLoadThresholdDlSpeech>
                                    <es:amr12200>50</es:amr12200>
                                    <es:amr7950>0</es:amr7950>
                                    <es:amr5900>100</es:amr5900>
                                    <es:amrWb8850>100</es:amrWb8850>
                                    <es:amrWb12650>100</es:amrWb12650>
                                    </es:pwrLoadThresholdDlSpeech>
                                    <es:aseLoadThresholdUlSpeech>
                                    <es:amr12200>0</es:amr12200>
                                    <es:amr7950>0</es:amr7950>
                                    <es:amr5900>100</es:amr5900>
                                    <es:amrWb8850>100</es:amrWb8850>
                                    <es:amrWb12650>100</es:amrWb12650>
                                    </es:aseLoadThresholdUlSpeech>
                                    <es:rateSelectionPsInteractive>
                                    <es:channelType>0</es:channelType>
                                    <es:csFallbackCsRelease>0</es:csFallbackCsRelease>
                                    <es:csFallbackDchToFach>0</es:csFallbackDchToFach>
                                    <es:dchToFach>0</es:dchToFach>
                                    <es:fachToUra>1</es:fachToUra>
                                    <es:fastDormancy>1</es:fastDormancy>
                                    <es:normalRelease>1</es:normalRelease>
                                    </es:releaseRedirectEutraTriggers>
                                    </es:vsDataUtranCell>
                                    </xn:attributes>
                                </xn:VsDataContainer>
                            </un:UtranCell>
                        </un:RncFunction>
                    </xn:ManagedElement>
                </xn:MeContext>
            </xn:SubNetwork>
        </xn:SubNetwork>
    </configData>
  <fileFooter dateTime="2013-10-02T11:40:14Z"/>
</bulkCmConfigDataFile>

I Need Below Output:-

Sub ID	UtranCell id	maxTxPowerUl	pwrLoadThresholdDlSpeech.amr12200	pwrLoadThresholdDlSpeech.amr5900	aseLoadThresholdUlSpeech.amr12200	aseLoadThresholdUlSpeech.amr5900
C01	NY431	              24	                   50	                         100	                                           0	                                   100

Don't Need Header but current value.

Thanks in Advance

2

Do you have a more complete example? Or can you at least tell what elements repeat inside of other elements?

3

Below Parameter are Repeat in XML

                             <es:pwrLoadThresholdDlSpeech>
                                    <es:amr12200>50</es:amr12200>
                                    <es:amr7950>0</es:amr7950>
                                    <es:amr5900>100</es:amr5900>
                                    <es:amrWb8850>100</es:amrWb8850>
                                    <es:amrWb12650>100</es:amrWb12650>
                               </es:pwrLoadThresholdDlSpeech>
                               <es:aseLoadThresholdUlSpeech>
                                    <es:amr12200>0</es:amr12200>
                                    <es:amr7950>0</es:amr7950>
                                    <es:amr5900>100</es:amr5900>
                                    <es:amrWb8850>100</es:amrWb8850>
                                    <es:amrWb12650>100</es:amrWb12650>
                               </es:aseLoadThresholdUlSpeech>