Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello:
I'm trying to data from a XML file, but I get this error message
Found a not valid character
On line number: 11. On column number: 12. System ID: MasVoz%20Demo.xml.
callATC:
LOAD account,
calldate,
cdrHost,
destination,
disposition,
duration,
id,
province,
service,
source,
hasrecord,
played,
hasfax
FROM [MasVoz Demo.xml] (XmlSimple, Table is [callATC])
On line 11 there is this content
<province>móvil</province>
QlikView doesn't like de word móvil ... a word with an accent mark
Is there a keyword or any way for loading XML files with accent mark words ??
I've attached the XML, it could help to test anything.
Thank you very much
Joaquín
try opening the xml file with notepad++ and change encoding to UTF-8 ("convert to UTF-8"). Then save and try again loding the xml with qlikview!
Hope that helps
Maybe this is helpful: Re: Re: Caractere inválido em load de XML
- Marcus
try opening the xml file with notepad++ and change encoding to UTF-8 ("convert to UTF-8"). Then save and try again loding the xml with qlikview!
Hope that helps
Hello:
The content of the XML file was in UTF-8 format but I previously saved it in ANSI format.
I have saved the file in UTF-8 format and finally IT WORKS NICE ... just as Frank wrote.
Thanks for you help
Joaquñin