Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Junk characters illegal for XML
Message
From
08/04/2014 09:54:58
Denis Filer
University of Oxford
United Kingdom
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
XML, XSD
Title:
Junk characters illegal for XML
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows Server 2012
Network:
Windows 2008 Server
Database:
MS SQL Server
Application:
Web
Miscellaneous
Thread ID:
01598264
Message ID:
01598264
Views:
48
Does anyone know a good way to remove illegal characters (i.e. disliked by XML) from text strings being exported to XML files. Some of our old databases, even some new, have erroneous characters (special symbols, right angles, odd smiley faces, and the like) which throw XML. We check of course for for XML tags < and >, & and also I pass strings through a whole series of STRTRAN() commands trying to trap and remove these - but all to often, another weird character crops up and throws the XML file. We are not using CDATA. Any hints here greatly appreciated. Denis
Next
Reply
Map
View

Click here to load this message in the networking platform