Friday 27 December 2019

character encoding - Convert File Names into UTF


I have a folder full of sub folders and files which are named using Hebrew encoding (Windows XP - Windows-1255). I now use Windows 7 and I want to convert all file names into UTF (Native Windows 7 which supports Hebrew characters).


Is there a tool to do so automatically?


Pay attention, I'm not after converting the internals of the file, only its file name.


Thanks!



Answer



Background


What is needed to be done to fix this is to find some way to automatically know each of these Gibberish characters which Hebrew character they were before being getting that way.


I compiled to such lists of characters. I've seen both kinds of corruptions, sometimes it was using one set and sometimes the other. Here are both sets (and here it is pasted in separate rows, which is needed for what we 'll be doing: Set 1 and Set 2):



  1. à=א á=ב â=ג ã=ד ä=ה å=ו æ=ז ç=ח è=ט é=י ê=ך ë=כ ì=ל í=ם î=מ ï=ן ð=נ ñ=ס ò=ע ó=ף ô=פ õ=ץ ö=צ ÷=ק ø=ר ù=ש ú=ת ‚=ג „=ד ‡=א ˆ=צ ‰=ה ˜=ק ¯=ר Á=ח Â=ו È=י Ê=ז Ë=ט Ì=ם Í=ך Î=כ Ï=ל Ò=ס Ó=מ Ô=ן Ù=פ Ú=ע Û=ף Æ=. ¨=, ß=' ¢="

  2. Ç=א ü=ב é=ג â=ד ä=ה à=ו å=ז ç=ח ê=ט ë=י è=ך ï=כ î=ל ì=ם Ä=מ Å=ן É=נ æ=ס Æ=ע ô=ף ö=פ ò=ץ û=צ ù=ק ÿ=ר Ö=ש Ü=ת




Got it Fixed!


To actually rename files and folders, I figured out an easy way to got this done using Bulk Rename Utility



  1. Open the programs and browse to the folder containing all the files with this kind of names. enter image description here

  2. In the bottom of the interface, in the Special section, click on Character Translations

  3. In the dialog that opens paste the whole list of the charachter set your files are displayed in from the Pastbin link above, and click OK
    enter image description here

  4. In the Filters section, place a checkmark at Subfolders if you want to do more then one folder at a time.

  5. Select all files and folder in the list (you should see the name it'll become after renaming it in the 2nd coulmn) and click Rename. And now all names should be displyed in Hebrew! enter image description here


No comments:

Post a Comment

How can I VLOOKUP in multiple Excel documents?

I am trying to VLOOKUP reference data with around 400 seperate Excel files. Is it possible to do this in a quick way rather than doing it m...