Solved

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

Posted on 2014-04-28
8
286 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:Bing CISM / CISSP
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
 
LVL 37

Expert Comment

by:Bing CISM / CISSP
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
Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

 
LVL 91

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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Windows 7 Home Premium - not updating 3 61
Can't get access/ownership to folder 3 84
Word Directory is not in the drop down list 4 24
Entity Framework 7 27
Article by: Lee
Windows 7 Ultimate and Enterprise (and 2008 R2) introduced a new feature you may not be aware of - Boot from VHD.   Boot from VHD (or what Microsoft refers to asNative Boot allows you to install Windows to a VHD (Virtual Hard Disk) file that is t…
The recent Microsoft changes on update philosophy for Windows pre-10 and their impact on existing WSUS implementations.
This Micro Tutorial will give you a basic overview of Windows DVD Burner through its features and interface. This will be demonstrated using Windows 7 operating system.
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…

929 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now