Batch Change .JPG File name: space with a dash

Hello, just wondering if i could recieve any help with the following problem.

I have a list of pictures that are named according to a certain part number in a folder. These pictures are in the following format:
"XXX-XXX-XXX-XXX ABC-XXX-XXX.jpg"

I wanted to see if there was a way to batch convert these picture file names within the folder. I wanted to repalce the space before "ABC" into a dash to make a consistent format that looks like the following:
"XXX-XXX-XXX-XXX-ABC-XXX-XXX.jpg"


Thanks

Try this - altering the path to suit:

Please Login or Register  to view this content.

thanks for the reply,

i tried typing this into run

shell "cmd.exe /c ren ""C:\Documents and Settings\Desktop\pictues\204-031-088-005 AGF-002-001.jpg"" C:\Documents and Settings\Desktop\pictures\204-031-088-005-AGF-002-001.jpg

I got an error saying windows canot find 'shell". Make sure you typed the name correctly, and then try again. To search for a file, click the Start button, and then click Search.

I then removed the word shell and it ran without an error but did not change the picture name as intended.

You weren't supposed to replace the question marks, just the file path. And that's VBA code, not destined for the run dialog. To run it as a macro in Excel:

Please Login or Register  to view this content.

and run the RenameFiles macro.

kmjamal,

Unfortunately you need to post your question in a new thread, it's against the forum rules to post a question in the thread of another user. If you create your own thread, any advice will be tailored to your situation so you should include a description of what you've done and are trying to do. Also, if you feel that this thread is particularly relevant to what you are trying to do, you can surely include a link to it in your new thread.