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
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
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
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.
RE: Rename drawing files in Win xp
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: Eng-Tips.com Forum Policies
Chinese prisoner wins Nobel Peace Prize