Solved

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

Posted on 2014-04-28
8
289 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
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!

 
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: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering 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

On some Windows 7 (SP1) computers, Windows Update becomes super slow even the computer is reasonably fast.  There's one solution that seemed to have worked well for me (after trying a few other suggested solutions).
The Windows functions GetTickCount and timeGetTime retrieve the number of milliseconds since the system was started. However, the value is stored in a DWORD, which means that it wraps around to zero every 49.7 days. This article shows how to solve t…
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…
This Micro Tutorial will give you a introduction in two parts how to utilize Windows Live Movie Maker to its maximum capability. This will be demonstrated using Windows Live Movie Maker on Windows 7 operating system.

680 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