ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Web query and special characters (https://www.excelbanter.com/excel-programming/356658-web-query-special-characters.html)

Marcelo[_10_]

Web query and special characters
 
Hello,
I have a simple HTML data dump which has special characters: áéíóúñ
In the HTML source I placed
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"

When I download this table, all the accents are translated into unprintable
characters.
I know there are macros which remove these unprintable characters, but then
the word in uncomplete

código gets downloaded as cädigo and cleaned up it turns into cdigo.

Any help would be apreciated.
Thanks



Marcelo[_10_]

Web query and special characters
 
this was fixed by changing the meta tag to
<meta HTTP-EQUIV="content-type" CONTENT="text/html; charset=UTF-8""Marcelo"
wrote in message
...
Hello,
I have a simple HTML data dump which has special characters: áéíóúñ
In the HTML source I placed
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"

When I download this table, all the accents are translated into

unprintable
characters.
I know there are macros which remove these unprintable characters, but

then
the word in uncomplete

código gets downloaded as cädigo and cleaned up it turns into cdigo.

Any help would be apreciated.
Thanks






All times are GMT +1. The time now is 01:53 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com