Continue to Site

Eng-Tips is the largest engineering community on the Internet

Intelligent Work Forums for Engineering Professionals

  • Congratulations cowski on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

Rename drawing files in Win xp 1

Status
Not open for further replies.

frankreid

Mechanical
Mar 9, 2007
92
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.
 
Replies continue below

Recommended for you

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
 
I have found nothing better for batch file renaming than a nine year old freeware program called 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.
 
There is a program specifically designed for this called "Bulk Rename Utility" or BRU.
Note that if your filenames have no other distinguishing features in their names, what you are trying to do will fail. But, you can certainly prefix or postfix the root filename with numbers in BRU.

TTFN

FAQ731-376
Chinese prisoner wins Nobel Peace Prize
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor