Renaming From a Database File Containing ID #'s

Post any Bulk Rename Utility support requirements here. Open to all registered users.

Renaming From a Database File Containing ID #'s

Postby JayShoe » Fri Apr 10, 2009 5:22 am

Hello,

I have a bunch of files that are named somthing like this:

001001.mpg
001002.mpg
001003.mpg

Then I have a .csv containing something like this

ID, Artist, Title
001001,Sample Artist,Sample Title
001002,Sample Artist2,Sample Title2
001003,Sample Artist3,Sample Title3

Can I rename the files to something like this using BRU?

Sample Artist - Sample Title.mpg
Sample Artist2 - Sample Title2.mpg
Sample Artist3 - Sample Title3.mpg

Or how about this?

Sample Artist\Sample Title.mpg
Sample Artist2\Sample Title2.mpg
Sample Artist3\Sample Title3.mpg

Thank you,
Jay
JayShoe
 
Posts: 3
Joined: Fri Apr 10, 2009 5:12 am

Re: Renaming From a Database File Containing ID #'s

Postby GMA » Fri Apr 10, 2009 7:59 pm

Hi, Jay:
Yes, you can do that, but you're gonna need a text editor that supports find & replace based on regular expressions.

1. Open the CVS file with said text editor and remove the first line ("ID, Artist, Title"). Then do a find & replace based on the following regular expression:

FIND: ([0-9]*),(.*?),(.*?)$
REPLACE: \1.mpg|\2 - \3.mpg

2. Save the file as a text document (TXT).
3. Open BRU. On the left pane (folder tree) select the folder that contains the files "001001.mpg", "001002.mpg", etc.
4. Go to "File > Import Rename-Pairs" and open the TXT file you just created (in step 3).
5. Select all the files on the right pane (press CTRL+A or use the "Actions > Select All" menu). Now you'll see a preview of the new names. If everything looks OK, you can press "Rename" now.

Or how about this?

Sample Artist\Sample Title.mpg
Sample Artist2\Sample Title2.mpg
Sample Artist3\Sample Title3.mpg

No, that's impossible because files can't have backslashes as part of their names.

Cheers,

Gabriel.
GMA
 
Posts: 91
Joined: Sun Dec 02, 2007 1:30 pm
Location: Argentina


Return to BRU Support