![]() ![]() I can accept that Windows designers could not have known that Apple was pursuing a different course, nor could they have known that Asia existed. The trouble is that (a) I am not told which characters have been replaced (-, é, ö, and so on) and (b) I cannot issue a rename command (Name xxx AS yyy) because the original name with illegal characters is, well, illegal. ![]() I can loop through my string array(18000) and test the existence of every file in the string array and locate 161 Full names that fail. Only when I go to make use of the Full name am I told “File does not exist”. Sadly the SHELL function (FI.Path) or the DIR statement returns a Full name with the illegal characters (Unicode chrW(8208) for a hyphen replaced by a legal hyphen (Chr(045))). The files are found quite easily my VBA code points to a folder T:\Music\ and grabs 18,000 FullNames of MP3 files, stores them in an array. My problem is RENAMEing the files once found. This thread tells me how to strip illegal characters, but that is not my problem. This thread suggests I educate Mac users, but I don’t fancy educating millions of You Tube folks who upload music tracks as MP4 files. ![]() This thread seems to offer a Python solution, but setting aside time to learn and install Python is beyond me right now. This Google Search returns a zillion threads telling me that illegal characters are illegal in Windows file names. Please see also " Puzzle for a rainy day" This thread is a brief alert on bad filenames. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
June 2023
Categories |