Convert XML files

[gayaneducation]

I need to convert following huge xml file like this
-----------------------

<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<nodeset>
   <option value="132.146.3.231" label="132.146.3.231"></option>
   <option value="122.333.4.444" label="122.333.4.444"></option>
</nodeset>

-----------------------

<?xml version="1.0" encoding="UTF-8" standalone="no"?>
 
<nodeSet>
    <node  name="21cnedc23" host="132.146.3.231" port="20014" />
    <node name="sjs005a002" host="10.189.33.42" port="60012" />
     <node name="sjs005w001" host="10.189.60.6" port="60012" />
    <node name="cbu072a013" host="10.24.80.130" port="20014" />
    <node name="cbu072a014" host="10.24.80.133" port="20014" />
    <node name="hwdust01" host="147.149.178.23" port="62004" />
 
    <node name="hwdusa31.devenv1.bt.co.uk" host="147.149.178.8" port="62004" />
    <node name="orpg-d" host="hwdusa31.devenv1.bt.co.uk" port="62004" />
    <node name="orpgs-2" host="hwdusa31.devenv1.bt.co.uk" port="62004" />
    <node name="orpg-i" host="hwdusa31.devenv1.bt.co.uk" port="62004" />
    <node name="hwdusa26.devenv1.bt.co.uk" host="147.149.178.240" port="62004"/>
    <node name="iwod.devenv1.bt.co.uk" host="hwdusa31.devenv1.bt.co.uk" port="62004"/>
 
    <node name="marsweb" host="efsnapp30.empft.openreach.co.uk" port="61001"/>
    <node name="marsapp" host="efsnapp27.empft.openreach.co.uk" port="61001"/>
 
    <node name="cbpweb01" host="10.24.85.145" port="60012"/>
    <node name="cbpweb02" host="10.24.85.146" port="60012"/>
    <node name="cbpweb03" host="10.24.85.155" port="60012"/>
    <node name="cbpweb04" host="10.24.85.156" port="60012"/>
 
    <node name="cbpapp05" host="cbpapp05.infra.openreach.co.uk" port="60012"/>
    <node name="cbpapp06" host="cbpapp06.infra.openreach.co.uk" port="60012"/>
 
    <node name="cbrweb01" host="10.24.85.147" port="60012"/>
    <node name="cbrweb02" host="10.24.85.148" port="60012"/>
 
    <node name="cbrweb03" host="cbrweb03.infra.openreach.co.uk" port="60012"/>
    <node name="cbrweb04" host="cbrweb04.infra.openreach.co.uk" port="60012"/>
    <node name="cbrapp04" host="cbrapp04.infra.openreach.co.uk" port="60012"/>
    <node name="cbpapp04" host="cbpapp04.infra.openreach.co.uk" port="60012"/>
    <node name="cbrapp05" host="cbrapp05.infra.openreach.co.uk" port="60012"/>
    <node name="cbrapp06" host="cbrapp06.infra.openreach.co.uk" port="60012"/>
    <node name="plutoapp" host="efsnapp26.empft.openreach.co.uk" port="20014"/>
    <node name="plutoweb" host="efsnapp29.empft.openreach.co.uk" port="60012"/>
    <replicationFarmSet>
        <replicationFarm name="MYFARMNAME">
            <nodeRef useNode="MyLocalHost"/>
        </replicationFarm>
    </replicationFarmSet>
</nodeSet>
 

[Dormilich]

please specify the question. what needs to be converted to what? what means do you use? what do you have accomplished so far?

make sure to wrap code/markup in [code] tags (or use the # button).

regards

[gayaneducation]

I need to convert this segment

<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<nodeSet>
<node name="21cnedc23" host="132.146.3.231" port="20014" />
<node name="sjs005a002" host="10.189.33.42" port="60012" />
<node name="sjs005w001" host="10.189.60.6" port="60012" />
<node name="cbu072a013" host="10.24.80.130" port="20014" />
</nodeSet>

to this simlest model

<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<nodeSet>
<option value="132.146.3.231" label="132.146.3.231"/>
<option value="10.189.33.42" label="10.189.33.42"/>
</nodeset>

** Java script code / perl module or is there a way of doing this

regards
gayan

[Dormilich]

once again - please use [code] tags or the # button when posting code.

there are several ways
- do an xsl transformation, any decent server script language should provide methods for that
- use DOM, any decent server script language should provide methods for that. javascript can do that as well.
- use XML methods (of PHP I know you could use SimpleXML, maybe there's something similar in Perl)

regards