MUSEUM-L Archives

Museum discussion list

MUSEUM-L@HOME.EASE.LSOFT.COM

Options: Use Forum View

Use Monospaced Font
Show Text Part by Default
Show All Mail Headers

Message: [<< First] [< Prev] [Next >] [Last >>]
Topic: [<< First] [< Prev] [Next >] [Last >>]
Author: [<< First] [< Prev] [Next >] [Last >>]

Print Reply
Subject:
From:
Lynita Langley-Ware <[log in to unmask]>
Reply To:
Museum discussion list <[log in to unmask]>
Date:
Thu, 1 Nov 2001 13:53:42 -0600
Content-Type:
text/plain
Parts/Attachments:
text/plain (63 lines)
Patricia,

I often rename large groups of files using a .bat file, and long files names
are supported in Win2000's "version" of DOS.  I use Excel to create the
sequence of commands (DOS rename in this case), in particular the
"concatenate" function.  Concatenate allows differing cells within Excel to
be combined into a string.  Copy and "paste-special > values" back into an
empty area of the excel spreadsheet.  Copy the values from excel and paste
to a text editor, notepad for example.  Save the notepad window as
"something.bat" in the directory of a duplicate set of images.  From DOS,
run the "something.bat" file to rename the images.

This should do the trick...it worked on a dummy set of data created to
simulate your situation.  Duplicate your images to a temporary directory and
run the bat file on the dupes...just to be safe.

Here are links to the spreadsheet and resulting bat file.

http://philware.mystarband.net/imagesrename.xls

http://philware.mystarband.net/imgren.bat

Good luck,
Phil Ware



----- Original Message -----
From: "Patti Davis-Perkins" <[log in to unmask]>
To: <[log in to unmask]>
Sent: Thursday, November 01, 2001 10:31 AM
Subject: renaming files using DOS


>
> I have a series of image files IMG0001.jpg - IMG0100.jpg that I need to
> rename 0197-3302-4230-001.base.jpg - 0197-3302-4230-100.base.jpg.  Does
> anyone know how/if I can do this in DOS under WINDOWS 2000?
>
> Thanks in advance!
> Patricia Davis-Perkins
> Canadian Museum of Civilization
>
> =========================================================
> Important Subscriber Information:
>
> The Museum-L FAQ file is located at
http://www.finalchapter.com/museum-l-faq/ . You may obtain detailed
information about the listserv commands by sending a one line e-mail message
to [log in to unmask] . The body of the message should read "help"
(without the quotes).
>
> If you decide to leave Museum-L, please send a one line e-mail message to
[log in to unmask] . The body of the message should read "Signoff
Museum-L" (without the quotes).

=========================================================
Important Subscriber Information:

The Museum-L FAQ file is located at http://www.finalchapter.com/museum-l-faq/ . You may obtain detailed information about the listserv commands by sending a one line e-mail message to [log in to unmask] . The body of the message should read "help" (without the quotes).

If you decide to leave Museum-L, please send a one line e-mail message to [log in to unmask] . The body of the message should read "Signoff Museum-L" (without the quotes).

ATOM RSS1 RSS2