×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Rename drawing files in Win xp

Rename drawing files in Win xp

Rename drawing files in Win xp

(OP)
I need help with a problem. I have several hundred file numbers with prefixes for the drawing process. They are like

XXX YY B40_12-23-41.dwg

I would like to rename them by stripping out the first seven caracters so that the file names just start with the B40_.

Thanks for you great help in this site.

Frank Reid



Frank Reid
Reid Engineering Services of Utah
-
You'll never know what you are worth until you learn to say NO.

RE: Rename drawing files in Win xp

You can do it with Excel and some text commands.

Create a single column dir listing of the files you want to rename.
Load that list into column A of Excel.
In column B put the word 'Rename'. No quotations.
In column E put a double " quote character.
In column C put a formula: =Concatenate($E$1,B1,$E$1)
In column D put a formula: =mid(A1,8,Len(A1)-7)

Hide columns A and E
Set auto width on all columns to get all characters
Save As to a (.prn) file
Rename this file to .BAT in the directory with your files and run it from a DOS window.
 

"Wildfires are dangerous, hard to control, and economically catastrophic."

Ben Loosli

RE: Rename drawing files in Win xp

I have found nothing better for batch file renaming than a nine year old freeware program called Renamer.

http://www.albert.nu/Programs/Renamer

You can strip out the characters with the Trim function under the edit menu.

I have no connection to this program or programmer beyond a grateful appreciation for it's ease of use, sophistication (the "multi-change" function), and speed.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources