Results 1 to 4 of 4
  1. #1
    4 Star Lounger
    Join Date
    Apr 2001
    Posts
    482
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Decoding HTML Encoding of Foreign Language Text in a Spreadsheet

    As many do, our company translated our GUI and messages into many foreign languages. I am responsible for editing (the English) and managing translation of these. I recently asked for a dump of all the GUI labels/messages, which they provided in a CSV file. I could easly open this in Excel, and it worked great for most languages. However, for some languages, I just saw text like "عرض ا" which I am told is HTML encoding for the language (in this case Arabic). I know Excel can show Arabic script, but how do I convert this encoding to the actual script? Thanks in advance for your help!!

  2. #2
    4 Star Lounger
    Join Date
    Apr 2001
    Posts
    482
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Forgive me for reposting, but I tried in 2 different browsers (Firefox 13, and IE9), and could not get the "Edit Post" feature to work. This is what I was going to edit my post to say: As many do, our company translated our GUI and messages into many foreign languages. I am responsible for editing (the English) and managing translation of these. I recently asked for a dump of all the GUI labels/messages, which they provided in a CSV file. I could easly open this in Excel, and it worked great for most languages. However, for some languages, I just saw text like "#1593;#1585;#1590; #1575;" which I am told is HTML encoding for the language (in this case Arabic). I know Excel can show Arabic script, but how do I convert this encoding to the actual script? Thanks in advance for your help!! (p.s. the funny thing is the first time I pasted some code in above, it actually automatically made it into the script. I removed the "&" from the above in hopes of it staying similar to what I currently see.)

  3. #3
    5 Star Lounger
    Join Date
    Jan 2004
    Location
    Praha
    Posts
    990
    Thanks
    56
    Thanked 106 Times in 91 Posts
    Do you have the Arabic language pack installed on the PC ?

    Also, what happens when you change the relevant cells to an Arabic font ?
    Last edited by MartinM; 2012-06-19 at 14:01.

  4. #4
    4 Star Lounger
    Join Date
    Apr 2001
    Posts
    482
    Thanks
    0
    Thanked 0 Times in 0 Posts
    As best I can tell, I do have the Arabic language pack, and this is not a font issue. I need to convert the HTML encoding to Arabic script, just as happened automatically when I tried my first post in this thread. I just need for that to happen within Excel.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •