Solved

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

Posted on 2014-04-28
8
288 Views
Last Modified: 2014-05-25
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
Comment
Question by:snkama95
8 Comments
 
LVL 37

Expert Comment

by:bbao
ID: 40028647
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
 
LVL 23

Expert Comment

by:Thomas Grassi
ID: 40028680
Does any of the files have a comma (,)  in them that will cause filenames to goto the next column in a csv file.
0
 

Author Comment

by:snkama95
ID: 40028754
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
Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

 
LVL 37

Expert Comment

by:bbao
ID: 40028906
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
 
LVL 92

Expert Comment

by:nobus
ID: 40029191
most long file names will be located in the same directories
renaming these directories would cure a lot
0
 

Author Comment

by:snkama95
ID: 40030673
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
 

Accepted Solution

by:
snkama95 earned 0 total points
ID: 40079545
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
 

Author Closing Comment

by:snkama95
ID: 40089275
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

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

You may have a outside contractor who comes in once a week or seasonal to do some work in your office but you only want to give him access to the programs and files he needs and keep privet all other documents and programs, can you do this on a loca…
Possible fixes for Windows 7 and Windows Server 2008 updating problem. Solutions mentioned are from Microsoft themselves. I started a case with them from our Microsoft Silver Partner option to open a case and get direct support from Microsoft. If s…
Windows 8 comes with a dramatically different user interface known as Metro. Notably missing from the new interface is a Start button and Start Menu. Many users do not like it, much preferring the interface of earlier versions — Windows 7, Windows X…
The Task Scheduler is a powerful tool that is built into Windows. It allows you to schedule tasks (actions) on a recurring basis, such as hourly, daily, weekly, monthly, at log on, at startup, on idle, etc. This video Micro Tutorial is a brief intro…

792 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question