I have an xml file that I want to import in Access. Access is doing a fine job of it except that it doesn't like having a "." in the name. So I basically want to replace "netw.NetworkElement" in "NetworkElement"

This is an example input

```
<SOAP:Envelope xmlns:SOAP="http://schemas.xmlsoap.org/soap/envelope/">
<SOAP:Header>
    <header xmlns="xmlapi_1.0">
        <requestID>client1:0</requestID>
        <requestTime>Feb 1, 2017 2:46:46 PM</requestTime>
        <responseTime>Feb 1, 2017 2:46:46 PM</responseTime>
    </header>
</SOAP:Header>
<SOAP:Body>
    <findResponse xmlns="xmlapi_1.0">
        <result>
            <netw.NetworkElement>
                <mgmtIpAddrType>ipv4</mgmtIpAddrType>
                <ipAddress>10.27.64.19</ipAddress>
                <baseMacAddress>C4-08-4A-07-97-C1</baseMacAddress>
                <systemAddress>10.27.64.19</systemAddress>
                <sysDescription>N/A</sysDescription>
                <outOfBandAddress>192.168.0.1</outOfBandAddress>
                <inBandSystemAddress>10.27.64.19</inBandSystemAddress>
                <inBandL3ManagementIf>0.0.0.0</inBandL3ManagementIf>
                <location>TL000075</location>
                <coordinates>10b, Shevchenko str., Tula</coordinates>
                <chassisType>sas_shelf_7210_m_24f2xfp_etr</chassisType>
                <productType>19</productType>
                <sysObjectId>.1.3.6.1.4.1.6527.6.2.1.2.2.3</sysObjectId>
                <latitudeInDegrees>0.0</latitudeInDegrees>
                <longitudeInDegrees>0.0</longitudeInDegrees>
                <neState>managed</neState>
                <locationId>0</locationId>
                <olcState>inService</olcState>
                <siteId>10.27.64.19</siteId>
                <deploymentState>0</deploymentState>
                <objectFullName>network:10.27.64.19</objectFullName>
                <name>10.27.64.19</name>
            </netw.NetworkElement>
            <netw.NetworkElement>
                <mgmtIpAddrType>ipv4</mgmtIpAddrType>
                <ipAddress>10.27.64.28</ipAddress>
                <baseMacAddress>C4-08-4A-07-1A-5D</baseMacAddress>
                <systemAddress>10.27.64.28</systemAddress>
                <sysDescription>N/A</sysDescription>
                <outOfBandAddress>192.168.2.3</outOfBandAddress>
                <inBandSystemAddress>10.27.64.28</inBandSystemAddress>
                <inBandL3ManagementIf>0.0.0.0</inBandL3ManagementIf>
                <location>TL000018</location>
                <coordinates>96, Sovetskaya av., Tula</coordinates>
                <chassisType>sas_shelf_7210_m_24f2xfp_etr</chassisType>
                <productType>19</productType>
                <sysObjectId>.1.3.6.1.4.1.6527.6.2.1.2.2.3</sysObjectId>
                <latitudeInDegrees>0.0</latitudeInDegrees>
                <longitudeInDegrees>0.0</longitudeInDegrees>
                <neState>managed</neState>
                <locationId>0</locationId>
                <olcState>inService</olcState>
                <siteId>10.27.64.28</siteId>
                <deploymentState>0</deploymentState>
                <objectFullName>network:10.27.64.28</objectFullName>
                <name>10.27.64.28</name>
            </netw.NetworkElement>
        </result>
    </findResponse>
</SOAP:Body>

```

This is the expected output:

```
<NetworkElement>
                <mgmtIpAddrType>ipv4</mgmtIpAddrType>
                <ipAddress>10.27.64.19</ipAddress>
                <baseMacAddress>C4-08-4A-07-97-C1</baseMacAddress>
                <systemAddress>10.27.64.19</systemAddress>
                <sysDescription>N/A</sysDescription>
                <outOfBandAddress>192.168.0.1</outOfBandAddress>
                <inBandSystemAddress>10.27.64.19</inBandSystemAddress>
                <inBandL3ManagementIf>0.0.0.0</inBandL3ManagementIf>
                <location>TL000075</location>
                <coordinates>10b, Shevchenko str., Tula</coordinates>
                <chassisType>sas_shelf_7210_m_24f2xfp_etr</chassisType>
                <productType>19</productType>
                <sysObjectId>.1.3.6.1.4.1.6527.6.2.1.2.2.3</sysObjectId>
                <latitudeInDegrees>0.0</latitudeInDegrees>
                <longitudeInDegrees>0.0</longitudeInDegrees>
                <neState>managed</neState>
                <locationId>0</locationId>
                <olcState>inService</olcState>
                <siteId>10.27.64.19</siteId>
                <deploymentState>0</deploymentState>
                <objectFullName>network:10.27.64.19</objectFullName>
                <name>10.27.64.19</name>
            </NetworkElement>
            <NetworkElement>
                <mgmtIpAddrType>ipv4</mgmtIpAddrType>
                <ipAddress>10.27.64.28</ipAddress>
                <baseMacAddress>C4-08-4A-07-1A-5D</baseMacAddress>
                <systemAddress>10.27.64.28</systemAddress>
                <sysDescription>N/A</sysDescription>
                <outOfBandAddress>192.168.2.3</outOfBandAddress>
                <inBandSystemAddress>10.27.64.28</inBandSystemAddress>
                <inBandL3ManagementIf>0.0.0.0</inBandL3ManagementIf>
                <location>TL000018</location>
                <coordinates>96, Sovetskaya av., Tula</coordinates>
                <chassisType>sas_shelf_7210_m_24f2xfp_etr</chassisType>
                <productType>19</productType>
                <sysObjectId>.1.3.6.1.4.1.6527.6.2.1.2.2.3</sysObjectId>
                <latitudeInDegrees>0.0</latitudeInDegrees>
                <longitudeInDegrees>0.0</longitudeInDegrees>
                <neState>managed</neState>
                <locationId>0</locationId>
                <olcState>inService</olcState>
                <siteId>10.27.64.28</siteId>
                <deploymentState>0</deploymentState>
                <objectFullName>network:10.27.64.28</objectFullName>
                <name>10.27.64.28</name>
            </NetworkElement>

```

I've read this forum, tried different xsl transformations, but I just don't understand how xsl work. So far, I've only been able to copy the input file :-(

```
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">

<!-- Template to match 'netw.NetworkElement' and replace with 'NetworkElement' -->
<xsl:template match="netw.NetworkElement">
    <NetworkElement>
        <xsl:apply-templates select="@*|node()" />
    </NetworkElement>
</xsl:template>

 <!-- Template to match all nodes, copy them and then apply templates to children. -->
<xsl:template match="@*|node()">
    <xsl:copy>
    <xsl:apply-templates select="@*|node()"/>
</xsl:copy>
</xsl:template>

```

Any help would be really appreciated