Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am importing data from a website (http://nl.wikipedia.org/wiki/Lijst_van_minimumloon_per_land), it's Dutch but it is imported fine
easy one:
LOAD
Land,
"Minimumloon in EUR" as euro
FROM [lib://Wikipedia]
(html, codepage is 1252, embedded labels, table is @1);
only the result remains:
â,¬ 94,79 instead of € 94,79
I already tried some
load
chr(8364) as euro
autogenerate 10;
and & chr(10) options, but no luck so far...
When you load the data make sure you have the Character Set set to Unicode (UTF-8) and the euro signs should load ok.
Or just change the connection string manually to (html, UTF8, embedded labels, table is @1);
When you load the data make sure you have the Character Set set to Unicode (UTF-8) and the euro signs should load ok.
Or just change the connection string manually to (html, UTF8, embedded labels, table is @1);
It works fine, thanks!