Rename Multiple Files Efficiently Using Excel or Google Docs

March 5, 2008 at 8:06 am (software, tips, winxp) (, , , , , )

link

batch renaming is what I picked up perl for in the first place. Then I found interesting software like 14arename (win only). I then also picked up abit of SED and AWK in linux.

I know about the batch rename feature in winxp but it didn’t occur to me I could do it in excel. Basically this page teaches you to use

“use SUBSTITUTE to change specific text in the filenames, use CONCATENATE() with DATE() if you want to add date to the filename, etc.” to create a column of rename commands in DOS. something like

ren  abcd.fa abcd.gbk

very old school i know but hey its a godsend in your colleagues windows box with no admin rights to install anything.

Advertisements

1 Comment

  1. Nikzb said,

    Amazing post., bro

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: