Problem in XML to XML transformation

jkuravatti · May 5th, 2006, 05:38 AM

Hi,

I have a XML file generated dynamically, which will look like

<?xml version="1.0" encoding="UTF-8"?>
<DCI
    xsi:noNamespaceSchemaLocation="/omcsw/7.0.3.5/data/datamodels/configexportsd.xsd" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
    <NEID>39</NEID>
    <deviceType>HCF</deviceType>
    <version>7_0</version>
     <MO MOCName="hcf.SCPOffice__2_0" objectId="0">
        <MOElement name="objectGDN">HCF=14%java.lang.String|LogicalSS 7=0%java.lang.String|SCPOffice=0%java.lang.String: hcf.SCPOffice__2_0</MOElement>
        <MOElement name="userLabel" valueNull="true"/>
        <MOElement name="numericElementId">39</MOElement>
        <MOElement name="children">
            <Array length="1">
                <ArrayElement>HCF=14%java.lang.String|LogicalSS7=0 %java.lang.String|SCPOffice=0%java.lang.String|ATM LinkAttributes=0%java.lang.String:hcf.ATMLinkAttri butes__2_0</ArrayElement>
            </Array>
        </MOElement>
        <MOElement name="s7Lan" valueNull="true"/>
        <MOElement name="s7SaalMpr" valueNull="true"/>
        <MOElement name="s7MprThresholds" valueNull="true"/>
        <MOElement name="s7RouteTmr" valueNull="true"/>
        <MOElement name="s7tld" valueNull="true"/>
        <MOElement name="s7M3Msgpri" valueNull="true"/>
        <MOElement name="hsa">0</MOElement>
        <MOElement name="iEMS_accessIdentifier" valueNull="true"/>
        <MOElement name="id">0</MOElement>
    </MO>
     <MO MOCName="hcf.HCF__7_0" objectId="14">
        <MOElement name="objectGDN">HCF=14%java.lang.String:hcf.HCF__ 7_0</MOElement>
        <MOElement name="userLabel">HCF14</MOElement>
        <MOElement name="numericElementId">39</MOElement>
        <MOElement name="children">
            <Array length="27">
                <ArrayElement>HCF=14%java.lang.String|PreferredHdf =0%java.lang.String:hcf.PreferredHdf__2_0</ArrayElement>
                <ArrayElement>HCF=14%java.lang.String|Access=0%jav a.lang.String:hcf.Access__7_0</ArrayElement>
                <ArrayElement>HCF=14%java.lang.String|LogicalSS7=0 %java.lang.String:hcf.LogicalSS7__4_0</ArrayElement>
                <ArrayElement>HCF=14%java.lang.String|StorageUnit= 0%java.lang.String:hcf.StorageUnit__2_0</ArrayElement>
                <ArrayElement>HCF=14%java.lang.String|HcfHdfConnTa ble={hcfHdfConnIndex=1%java.lang.Integer}:hcf.HcfH dfConnTable__2_0</ArrayElement>
                <ArrayElement>HCF=14%java.lang.String|HcfServer=0% java.lang.String:hcf.HcfServer__6_0</ArrayElement>
                <ArrayElement>HCF=14%java.lang.String|Hlrappl=0%ja va.lang.String:hcf.Hlrappl__7_0</ArrayElement>
                <ArrayElement>HCF=14%java.lang.String|SystemInform ation=0%java.lang.String:hcf.SystemInformation__2_ 0</ArrayElement>
                <ArrayElement>HCF=14%java.lang.String|Platform=0%j ava.lang.String:hcf.Platform__6_1</ArrayElement>
                <ArrayElement>HCF=14%java.lang.String|HcfHdfConnTa ble={hcfHdfConnIndex=2%java.lang.Integer}:hcf.HcfH dfConnTable__2_0</ArrayElement>
                <ArrayElement>HCF=14%java.lang.String|Ss7Entry=0%j ava.lang.String:hcf.Ss7Entry__2_0</ArrayElement>
                <ArrayElement>HCF=14%java.lang.String|CriticalIndi cators=0%java.lang.String:hcf.CriticalIndicators__ 2_0</ArrayElement>
                <ArrayElement>HCF=14%java.lang.String|HcfProtocolT ypeTable={hcfProtocolTypeIndex=1%java.lang.Integer }:hcf.HcfProtocolTypeTable__6_0</ArrayElement>
                <ArrayElement>HCF=14%java.lang.String|SiteData=0%j ava.lang.String:hcf.SiteData__2_0</ArrayElement>
                <ArrayElement>HCF=14%java.lang.String|NetworkGrowt h=0%java.lang.Integer:hcf.NetworkGrowth__6_1</ArrayElement>
                <ArrayElement>HCF=14%java.lang.String|StorageUnitD isk=0%java.lang.String:hcf.StorageUnitDisk__2_0</ArrayElement>
                <ArrayElement>HCF=14%java.lang.String|ServicePacka ge=0%java.lang.String:hcf.ServicePackage__2_0</ArrayElement>
                <ArrayElement>HCF=14%java.lang.String|SpServicePac kageTable={spNumber=15%java.lang.Integer}:hcf.SpSe rvicePackageTable__3_0</ArrayElement>
                <ArrayElement>HCF=14%java.lang.String|HcfPreferred HdfInfoChangedID=0%java.lang.String:hcf.HcfPreferr edHdfInfoChangedID__2_0</ArrayElement>
                <ArrayElement>HCF=14%java.lang.String|OvldCapacity =0%java.lang.String:hcf.OvldCapacity__2_0</ArrayElement>
                <ArrayElement>HCF=14%java.lang.String|HcfIfPreferr edHdfID=0%java.lang.String:hcf.HcfIfPreferredHdfID __2_0</ArrayElement>
                <ArrayElement>HCF=14%java.lang.String|S7ClusterPar amTable={s7ClusterParamNetworkId=ABCDE%java.lang.S tring}:hcf.S7ClusterParamTable__2_0</ArrayElement>
                <ArrayElement>HCF=14%java.lang.String|PlatformStat e=0%java.lang.String:hcf.PlatformState__2_0</ArrayElement>
                <ArrayElement>HCF=14%java.lang.String|HcfHdfConnSt atus=2%java.lang.Integer:hcf.HcfHdfConnStatus__2_0 </ArrayElement>
                <ArrayElement>HCF=14%java.lang.String|HcfHdfConnSt atus=1%java.lang.Integer:hcf.HcfHdfConnStatus__2_0 </ArrayElement>
                <ArrayElement>HCF=14%java.lang.String|ConnStatusTa ble=0%java.lang.String:hcf.ConnStatusTable__2_0</ArrayElement>
                <ArrayElement>HCF=14%java.lang.String|LogFile=0%ja va.lang.String:hcf.LogFile__2_0</ArrayElement>
            </Array>
        </MOElement>
        <MOElement name="latitu">NaN</MOElement>
        <MOElement name="sDHLRId">7</MOElement>
        <MOElement name="systemInfo" complex="true">HCF=14%java.lang.String|SystemInfor mation=0%java.lang.String:hcf.SystemInformation__2 _0</MOElement>
        <MOElement name="id">39</MOElement>
        <MOElement name="clusterId">5</MOElement>
        <MOElement name="servpac" complex="true">HCF=14%java.lang.String|ServicePack age=0%java.lang.String:hcf.ServicePackage__2_0</MOElement>
        <MOElement name="platformState" complex="true">HCF=14%java.lang.String|PlatformSta te=0%java.lang.String:hcf.PlatformState__2_0</MOElement>
        <MOElement name="Version">7_0</MOElement>
        <MOElement name="ss7Entry" complex="true">HCF=14%java.lang.String|Ss7Entry=0% java.lang.String:hcf.Ss7Entry__2_0</MOElement>
        <MOElement name="rackId">0</MOElement>
        <MOElement name="siteInfo" complex="true">HCF=14%java.lang.String|__Auto_CStr ucture=565716%java.lang.String:hcf.SiteInfo__2_0</MOElement>
        <MOElement name="s7ClusterParam" complex="true">HCF=14%java.lang.String|S7ClusterPa ramTable={s7ClusterParamNetworkId=ABCDE%java.lang. String}:hcf.S7ClusterParamTable__2_0</MOElement>
        <MOElement name="sync" complex="true">HCF=14%java.lang.String|__Auto_CStr ucture=565732%java.lang.String:hcf.Sync__6_0</MOElement>
        <MOElement name="baseVersion">6_3</MOElement>
        <MOElement name="ipAddress">0</MOElement>
        <MOElement name="AdminState">NE_UNMANAGED_STATE</MOElement>
        <MOElement name="iEMS_accessIdentifier" valueNull="true"/>
        <MOElement name="applStatus" complex="true">HCF=14%java.lang.String|Hlrappl=0%j ava.lang.String:hcf.Hlrappl__7_0</MOElement>
        <MOElement name="criticalIndicators" complex="true">HCF=14%java.lang.String|CriticalInd icators=0%java.lang.String:hcf.CriticalIndicators_ _2_0</MOElement>
        <MOElement name="hsa">2</MOElement>
        <MOElement name="Type">HCF</MOElement>
        <MOElement name="reflectedStates" complex="true">HCF=14%java.lang.String|__Auto_CStr ucture=565735%java.lang.String:iems.ReflectedState s__2_0</MOElement>
        <MOElement name="hcfProtocolType">
            <Array length="1">
                <ArrayElement>HCF=14%java.lang.String|HcfProtocolT ypeTable={hcfProtocolTypeIndex=1%java.lang.Integer }:hcf.HcfProtocolTypeTable__6_0</ArrayElement>
            </Array>
        </MOElement>
        <MOElement name="PreferredHdf" valueNull="true"/>
        <MOElement name="NEOperationalState">Not Available</MOElement>
        <MOElement name="platformInfo" complex="true">HCF=14%java.lang.String|Platform=0% java.lang.String:hcf.Platform__6_1</MOElement>
        <MOElement name="EventPriority">2</MOElement>
        <MOElement name="serverId">0</MOElement>
        <MOElement name="CollectStatistics">false</MOElement>
        <MOElement name="longit">NaN</MOElement>
        <MOElement name="NEState">1</MOElement>
        <MOElement name="omchUserLabel">HCF14</MOElement>
        <MOElement name="NGOperationState">1</MOElement>
        <MOElement name="positionId">0</MOElement>
        <MOElement name="NESoftwareVersion">600</MOElement>
        <MOElement name="hcfServer" complex="true">HCF=14%java.lang.String|HcfServer=0 %java.lang.String:hcf.HcfServer__6_0</MOElement>
        <MOElement name="AccessParams" complex="true">HCF=14%java.lang.String|Access=0%ja va.lang.String:hcf.Access__7_0</MOElement>
        <MOElement name="CommunicationState">0</MOElement>
        <MOElement name="UpgradeState">2</MOElement>
        <MOElement name="spServicePackage" complex="true">HCF=14%java.lang.String|SpServicePa ckageTable={spNumber=15%java.lang.Integer}:hcf.SpS ervicePackageTable__3_0</MOElement>
        <MOElement name="AdditionalData" valueNull="true"/>
        <MOElement name="common" complex="true">HCF=14%java.lang.String|SiteData=0% java.lang.String:hcf.SiteData__2_0</MOElement>
        <MOElement name="HeartbeatState">1</MOElement>
        <MOElement name="routingType" complex="true">HCF=14%java.lang.String|HcfIfPrefer redHdfID=0%java.lang.String:hcf.HcfIfPreferredHdfI D__2_0</MOElement>
        <MOElement name="alarmSynch">false</MOElement>
        <MOElement name="bOutofSynch">true</MOElement>
        <MOElement name="logFile" complex="true">HCF=14%java.lang.String|LogFile=0%j ava.lang.String:hcf.LogFile__2_0</MOElement>
        <MOElement name="ovldCapacity" complex="true">HCF=14%java.lang.String|OvldCapacit y=0%java.lang.String:hcf.OvldCapacity__2_0</MOElement>
        <MOElement name="NGPending">1</MOElement>
    </MO>
    <MO MOCName="hcf.ServicePackage__2_0" objectId="0">
        <MOElement name="objectGDN">HCF=14%java.lang.String|ServicePa ckage=0%java.lang.String:hcf.ServicePackage__2_0</MOElement>
        <MOElement name="userLabel" valueNull="true"/>
        <MOElement name="numericElementId">39</MOElement>
        <MOElement name="children">
            <Array length="0"/>
        </MOElement>
        <MOElement name="iEMS_accessIdentifier">%java.lang.String</MOElement>
        <MOElement name="hsa">0</MOElement>
        <MOElement name="spCount">15</MOElement>
    </MO>
</DCI>

The entries for <ArrayElement>HCF=14%java.lang.String|HcfPr otocolTypeTable={hcfProtocolTypeIndex=1%java.lang. Integer}:hcf.HcfProtocolTypeTable__6_0</ArrayElement> will be there in generated XML file, which can vary in number from 0 to 3. My aim is to remove <ArrayElement>
HCF=14%java.lang.String|HcfProtocolTypeTable={hcfP rotocolTypeIndex=1%java.lang.Integer}:hcf.HcfProto colTypeTable__6_0

</ArrayElement> entry (ie the <ArrayElement> tag containing the text hcf.HcfProtocolTypeTable__6_0) , when ever it is there as ArrayElement and assign the appropriate value for <Array length="X"> depending upon the number of entries removed. That means if I remove one entries then X can take value (X=27-1 i.e. 26-Exactly equals to the count of ArrayElement tag)

Along with this I need to change last three char for some of the text in the ArrayElement like
<ArrayElement>HCF=14%java.lang.String|Access=0%jav a.lang.String:hcf.Access__7_0</ArrayElement> to <ArrayElement>HCF=14%java.lang.String|Access=0%jav a.lang.String:hcf.Access__6_3</ArrayElement>

<ArrayElement>HCF=14%java.lang.String|HcfServer=0% java.lang.String:hcf.HcfServer__6_0</ArrayElement> to <ArrayElement>HCF=14%java.lang.String|HcfServer=0% java.lang.String:hcf.HcfServer__2_0</ArrayElement>

<ArrayElement>HCF=14%java.lang.String|Hlrappl=0%ja va.lang.String:hcf.Hlrappl__7_0</ArrayElement> to <ArrayElement>HCF=14%java.lang.String|Hlrappl=0%ja va.lang.String:hcf.Hlrappl__2_0</ArrayElement>

The output file should look like.

<?xml version="1.0" encoding="UTF-8"?>
<DCI xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="/omcsw/7.0.3.5/data/datamodels/configexportsd.xsd">
    <NEID>39</NEID>
    <deviceType>HCF</deviceType>
    <version>6_3</version>
    <MO MOCName="hcf.SCPOffice__2_0" objectId="0">
        <MOElement name="objectGDN">HCF=14%java.lang.String|LogicalSS 7=0%java.lang.String|SCPOffice=0%java.lang.String: hcf.SCPOffice__2_0</MOElement>
        <MOElement name="userLabel" valueNull="true"/>
        <MOElement name="numericElementId">39</MOElement>
        <MOElement name="children">
            <Array length="1">
                <ArrayElement>HCF=14%java.lang.String|LogicalSS7=0 %java.lang.String|SCPOffice=0%java.lang.String|ATM LinkAttributes=0%java.lang.String:hcf.ATMLinkAttri butes__2_0</ArrayElement>
            </Array>
        </MOElement>
        <MOElement name="s7Lan" valueNull="true"/>
        <MOElement name="s7SaalMpr" valueNull="true"/>
        <MOElement name="s7MprThresholds" valueNull="true"/>
        <MOElement name="s7RouteTmr" valueNull="true"/>
        <MOElement name="s7tld" valueNull="true"/>
        <MOElement name="s7M3Msgpri" valueNull="true"/>
        <MOElement name="hsa">0</MOElement>
        <MOElement name="iEMS_accessIdentifier" valueNull="true"/>
        <MOElement name="id">0</MOElement>
    </MO>
    <MO MOCName="hcf.HCF__7_0" objectId="14">
        <MOElement name="objectGDN">HCF=14%java.lang.String:hcf.HCF__ 7_0</MOElement>
        <MOElement name="userLabel">HCF14</MOElement>
        <MOElement name="numericElementId">39</MOElement>
        <MOElement name="children">
            <Array length="26">
                <ArrayElement>HCF=14%java.lang.String|PreferredHdf =0%java.lang.String:hcf.PreferredHdf__2_0</ArrayElement>
                <ArrayElement>HCF=14%java.lang.String|Access=0%jav a.lang.String:hcf.Access__6_3</ArrayElement>
                <ArrayElement>HCF=14%java.lang.String|LogicalSS7=0 %java.lang.String:hcf.LogicalSS7__4_0</ArrayElement>
                <ArrayElement>HCF=14%java.lang.String|StorageUnit= 0%java.lang.String:hcf.StorageUnit__2_0</ArrayElement>
                <ArrayElement>HCF=14%java.lang.String|HcfHdfConnTa ble={hcfHdfConnIndex=1%java.lang.Integer}:hcf.HcfH dfConnTable__2_0</ArrayElement>
                <ArrayElement>HCF=14%java.lang.String|HcfServer=0% java.lang.String:hcf.HcfServer__2_0</ArrayElement>
                <ArrayElement>HCF=14%java.lang.String|Hlrappl=0%ja va.lang.String:hcf.Hlrappl__2_0</ArrayElement>
                <ArrayElement>HCF=14%java.lang.String|SystemInform ation=0%java.lang.String:hcf.SystemInformation__2_ 0</ArrayElement>
                <ArrayElement>HCF=14%java.lang.String|Platform=0%j ava.lang.String:hcf.Platform__6_1</ArrayElement>
                <ArrayElement>HCF=14%java.lang.String|HcfHdfConnTa ble={hcfHdfConnIndex=2%java.lang.Integer}:hcf.HcfH dfConnTable__2_0</ArrayElement>
                <ArrayElement>HCF=14%java.lang.String|Ss7Entry=0%j ava.lang.String:hcf.Ss7Entry__2_0</ArrayElement>
                <ArrayElement>HCF=14%java.lang.String|CriticalIndi cators=0%java.lang.String:hcf.CriticalIndicators__ 2_0</ArrayElement>
                <ArrayElement>HCF=14%java.lang.String|SiteData=0%j ava.lang.String:hcf.SiteData__2_0</ArrayElement>
                <ArrayElement>HCF=14%java.lang.String|NetworkGrowt h=0%java.lang.Integer:hcf.NetworkGrowth__6_1</ArrayElement>
                <ArrayElement>HCF=14%java.lang.String|StorageUnitD isk=0%java.lang.String:hcf.StorageUnitDisk__2_0</ArrayElement>
                <ArrayElement>HCF=14%java.lang.String|ServicePacka ge=0%java.lang.String:hcf.ServicePackage__2_0</ArrayElement>
                <ArrayElement>HCF=14%java.lang.String|SpServicePac kageTable={spNumber=15%java.lang.Integer}:hcf.SpSe rvicePackageTable__3_0</ArrayElement>
                <ArrayElement>HCF=14%java.lang.String|HcfPreferred HdfInfoChangedID=0%java.lang.String:hcf.HcfPreferr edHdfInfoChangedID__2_0</ArrayElement>
                <ArrayElement>HCF=14%java.lang.String|OvldCapacity =0%java.lang.String:hcf.OvldCapacity__2_0</ArrayElement>
                <ArrayElement>HCF=14%java.lang.String|HcfIfPreferr edHdfID=0%java.lang.String:hcf.HcfIfPreferredHdfID __2_0</ArrayElement>
                <ArrayElement>HCF=14%java.lang.String|S7ClusterPar amTable={s7ClusterParamNetworkId=ABCDE%java.lang.S tring}:hcf.S7ClusterParamTable__2_0</ArrayElement>
                <ArrayElement>HCF=14%java.lang.String|PlatformStat e=0%java.lang.String:hcf.PlatformState__2_0</ArrayElement>
                <ArrayElement>HCF=14%java.lang.String|HcfHdfConnSt atus=2%java.lang.Integer:hcf.HcfHdfConnStatus__2_0 </ArrayElement>
                <ArrayElement>HCF=14%java.lang.String|HcfHdfConnSt atus=1%java.lang.Integer:hcf.HcfHdfConnStatus__2_0 </ArrayElement>
                <ArrayElement>HCF=14%java.lang.String|ConnStatusTa ble=0%java.lang.String:hcf.ConnStatusTable__2_0</ArrayElement>
                <ArrayElement>HCF=14%java.lang.String|LogFile=0%ja va.lang.String:hcf.LogFile__2_0</ArrayElement>
            </Array>
        </MOElement>
        <MOElement name="latitu">NaN</MOElement>
        <MOElement name="sDHLRId">7</MOElement>
        <MOElement name="systemInfo" complex="true">HCF=14%java.lang.String|SystemInfor mation=0%java.lang.String:hcf.SystemInformation__2 _0</MOElement>
        <MOElement name="id">39</MOElement>
        <MOElement name="clusterId">5</MOElement>
        <MOElement name="servpac" complex="true">HCF=14%java.lang.String|ServicePack age=0%java.lang.String:hcf.ServicePackage__2_0</MOElement>
        <MOElement name="platformState" complex="true">HCF=14%java.lang.String|PlatformSta te=0%java.lang.String:hcf.PlatformState__2_0</MOElement>
        <MOElement name="Version">7_0</MOElement>
        <MOElement name="ss7Entry" complex="true">HCF=14%java.lang.String|Ss7Entry=0% java.lang.String:hcf.Ss7Entry__2_0</MOElement>
        <MOElement name="rackId">0</MOElement>
        <MOElement name="siteInfo" complex="true">HCF=14%java.lang.String|__Auto_CStr ucture=565716%java.lang.String:hcf.SiteInfo__2_0</MOElement>
        <MOElement name="s7ClusterParam" complex="true">HCF=14%java.lang.String|S7ClusterPa ramTable={s7ClusterParamNetworkId=ABCDE%java.lang. String}:hcf.S7ClusterParamTable__2_0</MOElement>
        <MOElement name="sync" complex="true">HCF=14%java.lang.String|__Auto_CStr ucture=565732%java.lang.String:hcf.Sync__6_0</MOElement>
        <MOElement name="baseVersion">6_3</MOElement>
        <MOElement name="ipAddress">0</MOElement>
        <MOElement name="AdminState">NE_UNMANAGED_STATE</MOElement>
        <MOElement name="iEMS_accessIdentifier" valueNull="true"/>
        <MOElement name="applStatus" complex="true">HCF=14%java.lang.String|Hlrappl=0%j ava.lang.String:hcf.Hlrappl__7_0</MOElement>
        <MOElement name="criticalIndicators" complex="true">HCF=14%java.lang.String|CriticalInd icators=0%java.lang.String:hcf.CriticalIndicators_ _2_0</MOElement>
        <MOElement name="hsa">2</MOElement>
        <MOElement name="Type">HCF</MOElement>
        <MOElement name="reflectedStates" complex="true">HCF=14%java.lang.String|__Auto_CStr ucture=565735%java.lang.String:iems.ReflectedState s__2_0</MOElement>
        <MOElement name="hcfProtocolType">
            <Array length="0"/>
        </MOElement>
        <MOElement name="PreferredHdf" valueNull="true"/>
        <MOElement name="NEOperationalState">Not Available</MOElement>
        <MOElement name="platformInfo" complex="true">HCF=14%java.lang.String|Platform=0% java.lang.String:hcf.Platform__6_1</MOElement>
        <MOElement name="EventPriority">2</MOElement>
        <MOElement name="serverId">0</MOElement>
        <MOElement name="CollectStatistics">false</MOElement>
        <MOElement name="longit">NaN</MOElement>
        <MOElement name="NEState">1</MOElement>
        <MOElement name="omchUserLabel">HCF14</MOElement>
        <MOElement name="NGOperationState">1</MOElement>
        <MOElement name="positionId">0</MOElement>
        <MOElement name="NESoftwareVersion">600</MOElement>
        <MOElement name="hcfServer" complex="true">HCF=14%java.lang.String|HcfServer=0 %java.lang.String:hcf.HcfServer__6_0</MOElement>
        <MOElement name="AccessParams" complex="true">HCF=14%java.lang.String|Access=0%ja va.lang.String:hcf.Access__7_0</MOElement>
        <MOElement name="CommunicationState">0</MOElement>
        <MOElement name="UpgradeState">2</MOElement>
        <MOElement name="spServicePackage" complex="true">HCF=14%java.lang.String|SpServicePa ckageTable={spNumber=15%java.lang.Integer}:hcf.SpS ervicePackageTable__3_0</MOElement>
        <MOElement name="AdditionalData" valueNull="true"/>
        <MOElement name="common" complex="true">HCF=14%java.lang.String|SiteData=0% java.lang.String:hcf.SiteData__2_0</MOElement>
        <MOElement name="HeartbeatState">1</MOElement>
        <MOElement name="routingType" complex="true">HCF=14%java.lang.String|HcfIfPrefer redHdfID=0%java.lang.String:hcf.HcfIfPreferredHdfI D__2_0</MOElement>
        <MOElement name="alarmSynch">false</MOElement>
        <MOElement name="bOutofSynch">true</MOElement>
        <MOElement name="logFile" complex="true">HCF=14%java.lang.String|LogFile=0%j ava.lang.String:hcf.LogFile__2_0</MOElement>
        <MOElement name="ovldCapacity" complex="true">HCF=14%java.lang.String|OvldCapacit y=0%java.lang.String:hcf.OvldCapacity__2_0</MOElement>
        <MOElement name="NGPending">1</MOElement>
    </MO>
    <MO MOCName="hcf.ServicePackage__2_0" objectId="0">
        <MOElement name="objectGDN">HCF=14%java.lang.String|ServicePa ckage=0%java.lang.String:hcf.ServicePackage__2_0</MOElement>
        <MOElement name="userLabel" valueNull="true"/>
        <MOElement name="numericElementId">39</MOElement>
        <MOElement name="children">
            <Array length="0"/>
        </MOElement>
        <MOElement name="iEMS_accessIdentifier">%java.lang.String</MOElement>
        <MOElement name="hsa">0</MOElement>
        <MOElement name="spCount">15</MOElement>
    </MO>
</DCI>

Please help to solve this problem.

joefawcett · May 5th, 2006, 06:00 AM

I would use the identity transform and override the template that matches Array:

Code:

<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
  <xsl:param name="arrayItemToRemove" select="'ABC'" />
  <xsl:template match="node()|@*">
    <xsl:copy>
      <xsl:apply-templates select="node()|@*"/>
    </xsl:copy>
  </xsl:template>

  <xsl:template match="Array">
    <Array length="{@length - count(ArrayElement[. = $arrayItemToRemove])}">
      <xsl:apply-templates select="ArrayElement[not(. = $arrayItemToRemove)]"/>
    </Array>
  </xsl:template>
</xsl:stylesheet>

Alternatively, if the length attribute is always accurate then:

Code:

<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
  <xsl:param name="arrayItemToRemove" select="'ABC'" />
  <xsl:template match="node()|@*">
    <xsl:copy>
      <xsl:apply-templates select="node()|@*"/>
    </xsl:copy>
  </xsl:template>

  <xsl:template match="Array">
    <Array length="{count(ArrayElement[not(. = $arrayItemToRemove)])}">
      <xsl:apply-templates select="ArrayElement[not(. = $arrayItemToRemove)]"/>
    </Array>
  </xsl:template>
</xsl:stylesheet>

--

Joe (Microsoft MVP - XML)

joefawcett · May 5th, 2006, 11:21 AM

Editing questions so that they change dramatically makes life difficult for responders and users alike.
Firstly edits are not transmitted by email, secondly future users are confused when the answer given bears little relation to the question.
Edits are for small changes to responses of when some additional information can be added before a response is made.

That over I don't see the problem.
I gave you a generic solution that copies all content and modifies the ArrayElements.
You just have to changethe param arrayItemToRemove to whatever is the value of the elements you don't need, presumably:
HCF=14%java.lang.String|HcfProtocolTypeTable={hcfP rotocolTypeIndex=1%java.lang.Integer}:hcf.HcfProto colTypeTable__6_0

You can also write another template to match ArrayItem's that you want to alter, I'm sorry but I'm going dizzy just trying to read your XML, never mind understand the logic for deciding which elements need singling out.

--

Joe (Microsoft MVP - XML)