Discussion Forums > Technology

Batch file renaming (replacing strings) & directory listing

<< < (2/2)

Ixarku:
There are all sorts of ways to handle batch renaming of files.  When I've done this sort of thing in the past, I did it using MS Access.  I started with a simple VBA module to read a directory and write all of the file names into a table.  I had a second field in the table for the new file name, and I used Excel to manipulate my list and create new file names, then put those back into the table.  Another simple VBA procedure read the table, matched to the old file name, and replaced it with a new one.  VBA is pretty easy to learn, and the FileSystemObject is not difficult to work with.  You could do the same thing entirely in Excel using VBA, I just find it easier to work with recordsets in Access.

Sakura90:
For someone that could need something like this...

Someone other place I forgot (lol) told of of PFrank. As it advertises... it can do anything. By far the most complete renaming tool I ever saw :P. I used it for replacing a string in the names for another (romaji -> kanji in my case) and it went perfect ^_^

I made a csv file (just a txt with values separated by commas), loaded it in the program and poof, renaming done. Just as I wanted. Easy and no knowledge of scripts, programming, etc is needed. The renaming options are quite extensive.


Thanks anyway for you all :3

Navigation

[0] Message Index

[*] Previous page