
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Handling Special characters in xml data
Hi,
I am working on reading an xml file into my Qlikview App and the data contains special characters such as the ç and the registered trademark symbol. When trying to load these values into the Qlikview App, I am getting a message of:
An invalid character was found in text content.
On line number: 26. On column number: 2070.
Is there a way of handling these special characters when reading data from an xml file?
Thanks

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi Nielsh,
I have the same type of problem when I am reading the xml code from a qvd.
Did you got any responce yet??
Regards,

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Try with ASCII no instead of special character.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Yes, but how can track down which special character causes the issue???


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
These links might be of great help!
http://www.liquid-technologies.com/XML/EscapingData.aspx
http://en.wikipedia.org/wiki/List_of_XML_and_HTML_character_entity_references

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi Nikos,
The only way I could get Qlikview to read the file was by changing the character set from utf-8 to windows-1252 in the xml file. It looks like some of the characters which were in the xml file were not utf-8 compliant.
Thanks
Nilesh

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Please assure that is the first line of your xml
<?xml version='1.0' encoding='UTF-8'?>
