Multiple File Renaming

Aug 23, 2009 40 Replies

d

=A0 =A0 =A0...Jim Thompson

s

No, abusing the spreadsheet for batch file creation.

DIR /S /B >TEMP.CSV

open TEMP.CSV in the spreadsheet program. Copy the column into a place lower in the spreadsheet. Use the find and replace from cursor to change the names in the second copy. Move the second copy up into column B beside the ones in column A Insert a new column A Put the REN command in A1 and then copy it to the rest.

Now save this as TEMP.BAT in space delimited unquoted CSV mode

Join the Discussion

Have something to add? Share your thoughts — no account required.

Didn't find your answer?

Ask the community — no account required