Log In
Register
Home
I would like to import an xml file with this header:
<?xml version="1.0" encoding="windows-1250"?>
Some text are encoded for example:
<data>
<faktury>
<faktura>
<zdroj>Fakturácia</zdroj>
Using New Source - File -Xml command I get the attached table, where all non-english characters are unreadable.
How to achieve the correct encoding for xml file?
July 16, 2010
Offline
Hi Gejza,
In your query go back to the 'Source' step and click on the gear icon. In the dialog box under the File Origin choose 1252: Western European (Windows).
Then go back to the last step and the characters should display correctly.
Please let me know if it doesn't work.
Mynda
New Member
September 10, 2020
Offline
Hi,
If you use a function, for instance combining all SAF-T xml files of a folder, you can change the function code in the advanced editor you can change the Xml.Tables parameters, from Source = Xml.Tables(Parameter1) to Source = Xml.Tables(Parameter1,[],1252)
[] for null
1252 the encode number
let
Source = (Parameter1) => let
Source = Xml.Tables(Parameter1,[],1252),
Table1 = Source{1}[Table],
Table2 = Table1{2}[Table]
in
Table2
in
Source
Cheers
Luís
1 Guest(s)
