HKFuey
asked on
Strange character breaks XML
I am creating an XML file with VBA, certain characters are not allowed and I'm trying to filter them out.
Does anyone know what this is:
If I paste into word it gives me a question mark in a box. If I look at the record in SQL or Notepad, it just shows as a space.
Does anyone know what this is:
If I paste into word it gives me a question mark in a box. If I look at the record in SQL or Notepad, it just shows as a space.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
And just for future use, if you want, here are a couple of free tools that you could use on Windows to view a file and see the hex code of the text...
If you want a basic tool that is free, and has a portable install option (ZIP file) then take a good look at:
If you want one that's free, portable and has a bit more features and prettier look take a look at:
»bp
If you want a basic tool that is free, and has a portable install option (ZIP file) then take a good look at:
If you want one that's free, portable and has a bit more features and prettier look take a look at:
»bp
Great, glad that helped.
»bp
»bp
ASKER
Really quick response!