I am importing XML data.

 

If I want to import the URL of the following XML:

 

<charts>

     <chart>

           <name>Median Condo Value</name>

           <url>http://www.zillow.com/app?chartType=affordability_avgCondoValue&graphType=barChart&regionId=11093&regionType=6&service=chart</url>

     </chart>

 

Then I use this select statement:  <COL><DATA><xsl:value-of select="//charts/chart[name='Median Condo Value']/url"/></DATA></COL>

 

Here is my question.  I want to import a Data element that has a "&" in the <name> field.  For example:

 

Normally for the XML below (and as with the example above) I would enter this select statement:

 

<COL><DATA><xsl:value-of select="//page[name='Homes & Real Estate']/tables/table/data/attribute/values/city/value"/></DATA></COL>

 

...but the "&" is causing the import to fail.

 

Does anyone have a suggestion?

 

<page>

   <name>Homes & Real Estate</name>

   <tables>

       <table>

           <name>Homes & Real Estate Data</name>

           <data>

               <attribute>

                   <name>Owners</name>

                   <values>

                       <city>

                           <value type="percent">0.52513637</value>

                       </city>

                   </values>

               </attribute>

           </data>

       </table>

   <tables>

</page>

Found the Answer:  Substitute "&amp;" for "&" inside the quotes.