Update PDF names in Windows Explorer

I have some PDF drawings i need to rename Problem is some of the pdf names include the "&" symbol. This is a reserved word in ESRI and the attachments are not working.

 I would just like to Delete that from the name all together.
 So Plan&Profile becomes PlanProfile or Plan_Profile
 I can replace with and "_" as well. Either way is good with me.

I have not done any programming like this. I'm thinking it would be a process to select all the names in the folder check to see if "&" in the name then delete or replace that piece of TExt. then move on to the next one.

 I'm hoping to get some feedback on the best way to do this.
 Thanks
PtboGiserAsked:
Who is Participating?
 
Phillip BurtonConnect With a Mentor Director, Practice Manager and Computing ConsultantCommented:
Try using Advanced Renamer - www.advancedrenamer.com

It allows you to remove a pattern from the filename.
0
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
You can't have the character '&' in filenames.
0
Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

 
SimonCommented:
You can rename files using the FileSystemObject with a vbscript.

This link shows a reasonable example, though you'd probably want to use the replace() function rather than truncating the filename.
0
 
OnisanCommented:
Save the attached file to your desktop,
Open it with Notepad and
change the path to your folder from C:\Onisan   (my test folder path)

Then close and double click

Done.
rename.vbs
0
 
Joe Winograd, Fellow&MVEDeveloperCommented:
You've had several good suggestions on how to do this and I'm not going to add more ways. But I do want to comment on the post that says, "You can't have the character '&' in filenames." That is incorrect! The ampersand is a valid character for file names. For the record, the following characters are not allowed in Windows file names:

< (less than)
> (greater than)
: (colon)
" (double quote)
/ (forward slash)
\ (backslash)
| (vertical bar or pipe)
? (question mark)
* (asterisk)
Integer value zero (ASCII NUL character)
Integer values 1-31 (except for alternate data streams, where these characters are allowed)

Regards, Joe
0
 
PtboGiserAuthor Commented:
This is a real nice easy tool.
Thanks worked perfectly.
0
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
@Joe:
That's the problem to work more with Command Prompt than Windows GUI.
The only way you can create a file with '&' in the name using Command Prompt is to put the names inside quotes. For example: "ABC&D.txt". Using Windows GUI or a Save File As... option I've realized that you can use the '&' without any problem.
0
 
Joe Winograd, Fellow&MVEDeveloperCommented:
> The only way you can create a file with '&' in the name using Command Prompt is to put the names inside quotes.

Also true for a space. But the point is, ampersand is a perfectly valid character in a file name (as is a space).
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.