Altova Mailing List Archives>Archive Index >comp.text.xml Archive Home >Recent entries [Thread Prev] >Thread Next - Re: Dealing with < and > characters in XML data Dealing with < and > characters in XML dataTo: NULL Date: 8/2/2006 3:24:00 PM
I've been using Access to import some data straight into a sql server
database by simply importing the xml file. However lately some of the
newer xml files will contain vaild data such as
"m<sup>3</sup>" within the tags so it reads like the following
<TblPartDesriptions_to_translate>
<intpartid>79</intpartid>
<strpartdescription>Part Description Here</strpartdescription>
<strlongdescription>some really long text here
m<sup>3</sup>/min.)</strlongdescription>
</TblPartDesriptions_to_translate>
The data inside the strlongdescription should just parse correctly but
it could just be a microsoft thing, since it does parse correctly in
other products such as "XML PAD" and Firefox for viewing the file.
any help is appreciated, perhaps a modified xsl file?
| ||||||
| Company | Legal | Press | Partners | Careers | Sitemap | Contact Us | Altova Blog | Mobile | Full Site | |||
|
