What is the best way to locate file names that are too long
Posted on 2014-04-28
I am experiencing problems with a couple of different computers. Both running Windows 7 32 bit. Seems the common denominator is that each machine has file names that appear to be too long. Unfortunately, I do not know where to find these files as there are thousands of directories and file names.
I have tried using a dos window approach where a command created a csv file with every file name on the computer. From there, I opened it in Excel and tried to use a LEN command on each line item in an adjacent cell to get the character length of each file. The intent was then to sort by that column to locate which files had the longest names.
The problem with that method is that it created the csv file with all sorts of errors with text appearing in the second column. I am not talking about the text simply showing in the adjacent column due to the length in the first, but actual text in the cells themselves. That made it so that when I tried to copy down the LEN command to all rows, the copy command would break at each row containing text.
So I am looking for a better approach. My objective right now does not concern itself with renaming file names that are too long, but simply finding them.