XML / XSL

<items>
  <item val="1"/>
  <item val="0"/>
  <item val="1"/>
</items>

<item val="1"/>
<item val="1"/>

<?xml version="1.0" ?>
<statement>
  <accounts>
    <account number="22">
      <currency symbol="USD">
        <transactions>
          <transaction>
          <id>1</id>
          </transaction>
        </transactions>
      </currency>
      <currency symbol="EUR">
        <transactions>
          <transaction>
          <id>2</id>
          </transaction>
        </transactions>
      </currency>
    </account>
  </accounts>
</statement>

<?xml version="1.0" encoding="ISO-8859-1" standalone="no" ?>
<xsl:stylesheet version="1.0" 
xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xsl:output method="xml" version="1.0" standalone="yes"/>
<xsl:template match="/">
<xsl:element name="VFPData">
<xsl:apply-templates/>
</xsl:element>
</xsl:template>
<xsl:template match="/statement/accounts/account/currency/transactions/*">
<xsl:element name="result">
<xsl:element name="id"><xsl:value-of select="id"/></xsl:element>
<xsl:element name="currency"><xsl:value-of 
select="../../../currency/@symbol"/></xsl:element>
</xsl:element>
</xsl:template>
</xsl:stylesheet>

<?xml version="1.0" encoding="UTF-16" standalone="yes"?>
<VFPData><result>
<id>1</id>
<currency>USD</currency>
</result>
<result><id>2</id>
<currency>USD</currency>
</result></VFPData>

[\w?\-?.?\s?\'?,?#?-[_]]

xs:pattern="[\w?\-?.?\s?\'?,?#?-[_]]"

newFName = fname.Substring(0, fname.Length - 4) + ".DAT";
System.IO.StreamWriter sw = new System.IO.StreamWriter(Server.MapPath(newFName));
XmlTextReader reader = new XmlTextReader("C:\\Projects\\CSNew2\\" + fname);

                        while (reader.Read())
                        {
                            switch (reader.NodeType)
                            {
                                case XmlNodeType.Element: // The node is an element.
                                    break;
                                case XmlNodeType.Text: //Display the text in each element.
                                    sw.WriteLine(reader.Value);
                                    break;
                                case XmlNodeType.EndElement: //Display the end of the element.
                                    //sw.Write("</" + reader.Name);
                                    //sw.WriteLine(">");
                                    break;
                            }
                        }
                        sw.Close();