I wrote a VB .NET program that part of it is reading from a SQL Server
2000 database and outputting data to XML. Problem is when I go to
transform the XML, from time to time, the data is bad as it contains
some of the bad XML characters like those below 0x20 ()
Below is the command I'm using to do this.
SQLDataset.Writ eXml("c:\temp\o utput.xml", XmlWriteMode.Wr iteSchema)
So besides except for 0x09 ( ), 0x0A ( ), and 0x0D( ) is
there a way to filter out all characters under 0x20 as it writes to the
XML text file, replacing it with a space or nothing at all?
Thanks.
JR
2000 database and outputting data to XML. Problem is when I go to
transform the XML, from time to time, the data is bad as it contains
some of the bad XML characters like those below 0x20 ()
Below is the command I'm using to do this.
SQLDataset.Writ eXml("c:\temp\o utput.xml", XmlWriteMode.Wr iteSchema)
So besides except for 0x09 ( ), 0x0A ( ), and 0x0D( ) is
there a way to filter out all characters under 0x20 as it writes to the
XML text file, replacing it with a space or nothing at all?
Thanks.
JR