[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 298
  • Last Modified:

What is the best way to locate file names that are too long

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.

Thank you.
0
snkama95
Asked:
snkama95
1 Solution
 
bbaoIT ConsultantCommented:
are you talking about full path name including the drive letter, all parental folder names and the file name itself, or just the file name that is too long?
0
 
Thomas GrassiSystems AdministratorCommented:
Does any of the files have a comma (,)  in them that will cause filenames to goto the next column in a csv file.
0
 
snkama95Author Commented:
Yes, I am including the drive letter and full path.  With respect to the comma, I do not know, but I am inclined to doubt it.  That is something that I would never use.
0
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
bbaoIT ConsultantCommented:
you may try this utility to find and verify the long file names.

it seems the long file names are some kind of trouble for you to maintain the file system. are you looking for a way to shorten the path name for some applications?
0
 
nobusCommented:
most long file names will be located in the same directories
renaming these directories would cure a lot
0
 
snkama95Author Commented:
bbao,

Thank you for offering a link to a possible solution.  Prior to clicking on it, would you be so kind as to explain where it is taking me?  I am extremely gun shy of going to unknown 3rd party websites, notwithstanding having suitable AV type software installed.

Thanks
0
 
snkama95Author Commented:
I have since located a program called Ultra FileSearch.   It has helped me to locate the files in question, as well as renaming them.  I would encourage anyone else that is having the same problem to give this a try.

Thanks
0
 
snkama95Author Commented:
I did not feel that anyone really responded to the actual issue, plus the fact that I was eventually able to locate, on my own, a software solution that completely provided the answer to the question.  Ultra FileSearch appeared to be the best result and only acceptable solution.   Although another solution was proposed, it required going to an unknown website.  Although I asked for detail regarding the website, no explanation was offered.  That was not a risk that I was willing to take.
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now