Solved

Update PDF names in Windows Explorer

Posted on 2015-02-12
9
164 Views
Last Modified: 2015-02-12
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
0
Comment
Question by:PtboGiser
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
9 Comments
 
LVL 25

Expert Comment

by:Lee Savidge
ID: 40605703
0
 
LVL 51

Expert Comment

by:Vitor Montalvão
ID: 40605712
You can't have the character '&' in filenames.
0
 
LVL 24

Accepted Solution

by:
Phillip Burton earned 500 total points
ID: 40605714
Try using Advanced Renamer - www.advancedrenamer.com

It allows you to remove a pattern from the filename.
0
Percona Live Europe 2017 | Sep 25 - 27, 2017

The Percona Live Open Source Database Conference Europe 2017 is the premier event for the diverse and active European open source database community, as well as businesses that develop and use open source database software.

 
LVL 18

Expert Comment

by:Simon
ID: 40605718
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
 
LVL 3

Expert Comment

by:Onisan
ID: 40605786
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
 
LVL 54

Expert Comment

by:Joe Winograd, EE MVE 2015&2016
ID: 40605958
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
 

Author Closing Comment

by:PtboGiser
ID: 40605968
This is a real nice easy tool.
Thanks worked perfectly.
0
 
LVL 51

Expert Comment

by:Vitor Montalvão
ID: 40605995
@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
 
LVL 54

Expert Comment

by:Joe Winograd, EE MVE 2015&2016
ID: 40606024
> 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

Featured Post

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

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

When you’re making plans to join the modern business race, you should analyze various details that may affect your results. Nowadays, millions of businesses are trying to grow into established and appreciated professional enterprises.
What if you have to shut down the entire Citrix infrastructure for hardware maintenance, software upgrades or "the unknown"? I developed this plan for "the unknown" and hope that it helps you as well. This article explains how to properly shut down …
Via a live example, show how to setup several different housekeeping processes for a SQL Server.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

615 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