Convert & to & etc.

[loris]

Dear All,

I am parsing some HTML with HTML::Parser and need to convert the ampersands and umlauts from stuff like & and ü to something more reasonable (in my case, Excel-friendly).

Can anyone point me in the right direction?

Thanks,

loris

[poolpi]

See HTML::Entities
hth,

Poolpi

[loris]

Thanks, that works fine for the ampersands, but not for my umlauts. I assume this is because, say, ü is encoded not as ü, but as ü, whatever that is. Do you know what sort of encoding this is and how I can deal with it?

Thanks,

loris

[moritz]

When you parse websites you have to consult the HTTP headers (and perhaps the http-equiv meta tags) to find out which charset it is in.

Then you can use Encode::decode to transform it into something useful.

(Perhaps inspecting a hexdump of the string helps you to find out which charset it is in).

[Tux]

If you are using Spreadsheet::WriteExcel, you can use its functionality directly:

  use Spreadsheet::WriteExcel;
  use HTML::Entities;
  use Encode qw( from_to );

  from_to (decode_entities ($value), "utf-8", "ucs2");
  $wks->write_unicode ($column, $row, $value);

[moritz]

HTML::Entities