Is there Perl code that can successfully interpret an input file having special characters from multiple European languages? My input file is an Excel spreadsheet in which each column contains data from a different European language.

My input file has multiple West European and East Eurpean languages using Latin characters ONLY, none of them use Cyrillic characters.

Example: What if the input file had the special characters listed below?

Polish ñ (Perlmonks site is not rendering this char it should be a n with a tick mark that slants upward and to the right.
Czech Š
German ä
French ë é
Spanish ó í ñ

After reading my input file, I need to write out selected parts of it to an ANSII *.ini file.

Can anyone provide Perl code that correctly sets up the input file pointers and output file pointers (described above) correctly?

The input file pointer would be associated with an Excel file containing special characters in several European languages that use Latin (not Cyrillic) characters.

The output file pointer would be associated with an *.ini file that must be in ASCII format

In reply to Interpreting input file having special characters from multiple European languages by Amphiaraus

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.