Sign in with
Sign up | Sign in
Your question

Renaming files in a folder

Last response: in Windows XP
Share
Anonymous
June 15, 2005 4:42:03 PM

Archived from groups: microsoft.public.windowsxp.general (More info?)

How can rename every file in a particular folder by replacing just certain
words? I need to replace 3 non connected words in each file name with the
same word for each file. It has been a long time and I have tried doing this
two ways through the command prompt and can not get it to work.

Please help!

Thank you!

More about : renaming files folder

Anonymous
June 15, 2005 7:03:28 PM

Archived from groups: microsoft.public.windowsxp.general (More info?)

A really complicated rename can be done with Excel or other spreadsheet
program. and then make a BAT file

First DIR > filelist.txt

gets you a listing to work with

Pop a copy into the spreadsheet workbook sheet one and a second copy on
sheet two.

On sheet one insert a column left of the names and fill it with "rename"

On sheet 2 do a find and replace for the "words" you need to change out

Now copy column A from sheet 2 over to column C on sheet 1
So "rename" is column A, and old filename is in colunm B, and
newfilename is column C

Now save sheet 1 as text.

you should have a file with one line per file to be renamed, rename to
to newname.bat and run it to change the names.

JenYancey wrote:

> How can rename every file in a particular folder by replacing just certain
> words? I need to replace 3 non connected words in each file name with the
> same word for each file. It has been a long time and I have tried doing this
> two ways through the command prompt and can not get it to work.
>
> Please help!
>
> Thank you!
Anonymous
June 15, 2005 7:03:29 PM

Archived from groups: microsoft.public.windowsxp.general (More info?)

Okay Bob. These are Word documents which I am talking about. They are all
in the same folder and this is all that is in the folder. Is there no way to
use the rename or replace function at the command prompt to replace the words
which I need to change? What you have explained sounds more complicated than
what I have been doing. I guess I thought there had to be an easier way than
renaming each file seperately by right clicking and changing the 3 words on
every file. Maybe there isn't. Thank you for your response. I hope there
is an easier way!

"Bob I" wrote:

> A really complicated rename can be done with Excel or other spreadsheet
> program. and then make a BAT file
>
> First DIR > filelist.txt
>
> gets you a listing to work with
>
> Pop a copy into the spreadsheet workbook sheet one and a second copy on
> sheet two.
>
> On sheet one insert a column left of the names and fill it with "rename"
>
> On sheet 2 do a find and replace for the "words" you need to change out
>
> Now copy column A from sheet 2 over to column C on sheet 1
> So "rename" is column A, and old filename is in colunm B, and
> newfilename is column C
>
> Now save sheet 1 as text.
>
> you should have a file with one line per file to be renamed, rename to
> to newname.bat and run it to change the names.
>
> JenYancey wrote:
>
> > How can rename every file in a particular folder by replacing just certain
> > words? I need to replace 3 non connected words in each file name with the
> > same word for each file. It has been a long time and I have tried doing this
> > two ways through the command prompt and can not get it to work.
> >
> > Please help!
> >
> > Thank you!
>
>
Related resources
Anonymous
June 15, 2005 7:03:30 PM

Archived from groups: microsoft.public.windowsxp.general (More info?)

Okay Bob. I have done this and after I was finished I saved the file as a
..txt file. Then I am in the folder where I want to run this file, I type Run
and the file path of the .txt file and it tells me that run is not recognized
as an internal or external command, operable program or batch file. I took
out the run thinking if I just typed in the path of the file it might run it
and it tells me the same thing about C:\Documents which is where I have my
file saved. I must be doing something wrong. Can you help me?

"JenYancey" wrote:

> Okay Bob. These are Word documents which I am talking about. They are all
> in the same folder and this is all that is in the folder. Is there no way to
> use the rename or replace function at the command prompt to replace the words
> which I need to change? What you have explained sounds more complicated than
> what I have been doing. I guess I thought there had to be an easier way than
> renaming each file seperately by right clicking and changing the 3 words on
> every file. Maybe there isn't. Thank you for your response. I hope there
> is an easier way!
>
> "Bob I" wrote:
>
> > A really complicated rename can be done with Excel or other spreadsheet
> > program. and then make a BAT file
> >
> > First DIR > filelist.txt
> >
> > gets you a listing to work with
> >
> > Pop a copy into the spreadsheet workbook sheet one and a second copy on
> > sheet two.
> >
> > On sheet one insert a column left of the names and fill it with "rename"
> >
> > On sheet 2 do a find and replace for the "words" you need to change out
> >
> > Now copy column A from sheet 2 over to column C on sheet 1
> > So "rename" is column A, and old filename is in colunm B, and
> > newfilename is column C
> >
> > Now save sheet 1 as text.
> >
> > you should have a file with one line per file to be renamed, rename to
> > to newname.bat and run it to change the names.
> >
> > JenYancey wrote:
> >
> > > How can rename every file in a particular folder by replacing just certain
> > > words? I need to replace 3 non connected words in each file name with the
> > > same word for each file. It has been a long time and I have tried doing this
> > > two ways through the command prompt and can not get it to work.
> > >
> > > Please help!
> > >
> > > Thank you!
> >
> >
Anonymous
June 15, 2005 7:57:01 PM

Archived from groups: microsoft.public.windowsxp.general (More info?)

Well it's like this, I don't know the file names, and I don't know what
words are to be replaced, and I don't know what number of letters in the
words to be replaced is, or if letters are to be added or subtracted
making the file names longer or shorter. I gave you a method that will
work. Plus you can look at the bat file and tell whether it's right or
not before you run it. So I ask, you want easy, or you want right? Other
possibility is to find someone else to do it, I guess.

JenYancey wrote:

> Okay Bob. These are Word documents which I am talking about. They are all
> in the same folder and this is all that is in the folder. Is there no way to
> use the rename or replace function at the command prompt to replace the words
> which I need to change? What you have explained sounds more complicated than
> what I have been doing. I guess I thought there had to be an easier way than
> renaming each file seperately by right clicking and changing the 3 words on
> every file. Maybe there isn't. Thank you for your response. I hope there
> is an easier way!
>
> "Bob I" wrote:
>
>
>>A really complicated rename can be done with Excel or other spreadsheet
>>program. and then make a BAT file
>>
>>First DIR > filelist.txt
>>
>>gets you a listing to work with
>>
>>Pop a copy into the spreadsheet workbook sheet one and a second copy on
>>sheet two.
>>
>>On sheet one insert a column left of the names and fill it with "rename"
>>
>>On sheet 2 do a find and replace for the "words" you need to change out
>>
>>Now copy column A from sheet 2 over to column C on sheet 1
>>So "rename" is column A, and old filename is in colunm B, and
>>newfilename is column C
>>
>>Now save sheet 1 as text.
>>
>>you should have a file with one line per file to be renamed, rename to
>>to newname.bat and run it to change the names.
>>
>>JenYancey wrote:
>>
>>
>>>How can rename every file in a particular folder by replacing just certain
>>>words? I need to replace 3 non connected words in each file name with the
>>>same word for each file. It has been a long time and I have tried doing this
>>>two ways through the command prompt and can not get it to work.
>>>
>>>Please help!
>>>
>>>Thank you!
>>
>>
Anonymous
June 15, 2005 8:22:44 PM

Archived from groups: microsoft.public.windowsxp.general (More info?)

My last line of instructions were

you should have a file with one line per file to be renamed, rename to
"newname.bat" and run it to change the names

JenYancey wrote:

> Okay Bob. I have done this and after I was finished I saved the file as a
> .txt file. Then I am in the folder where I want to run this file, I type Run
> and the file path of the .txt file and it tells me that run is not recognized
> as an internal or external command, operable program or batch file. I took
> out the run thinking if I just typed in the path of the file it might run it
> and it tells me the same thing about C:\Documents which is where I have my
> file saved. I must be doing something wrong. Can you help me?
>
> "JenYancey" wrote:
>
>
>>Okay Bob. These are Word documents which I am talking about. They are all
>>in the same folder and this is all that is in the folder. Is there no way to
>>use the rename or replace function at the command prompt to replace the words
>>which I need to change? What you have explained sounds more complicated than
>>what I have been doing. I guess I thought there had to be an easier way than
>>renaming each file seperately by right clicking and changing the 3 words on
>>every file. Maybe there isn't. Thank you for your response. I hope there
>>is an easier way!
>>
>>"Bob I" wrote:
>>
>>
>>>A really complicated rename can be done with Excel or other spreadsheet
>>>program. and then make a BAT file
>>>
>>>First DIR > filelist.txt
>>>
>>>gets you a listing to work with
>>>
>>>Pop a copy into the spreadsheet workbook sheet one and a second copy on
>>>sheet two.
>>>
>>>On sheet one insert a column left of the names and fill it with "rename"
>>>
>>>On sheet 2 do a find and replace for the "words" you need to change out
>>>
>>>Now copy column A from sheet 2 over to column C on sheet 1
>>>So "rename" is column A, and old filename is in colunm B, and
>>>newfilename is column C
>>>
>>>Now save sheet 1 as text.
>>>
>>>you should have a file with one line per file to be renamed, rename to
>>>to newname.bat and run it to change the names.
>>>
>>>JenYancey wrote:
>>>
>>>
>>>>How can rename every file in a particular folder by replacing just certain
>>>>words? I need to replace 3 non connected words in each file name with the
>>>>same word for each file. It has been a long time and I have tried doing this
>>>>two ways through the command prompt and can not get it to work.
>>>>
>>>>Please help!
>>>>
>>>>Thank you!
>>>
>>>
!