Add the names in 2 Lists Of Files together

Advanced Renamer forum
#1 : 24/04-15 19:09
David
David
Posts: 59
I want to add the names from 2 different lists of files into a new filename for the files.
Is there a way to do this?

ie:
Examples from the first list
Batman v2 001 - Life Lines Part 1
Batman v2 002 - Life Lines Part 2

Examples from the second list
01 - Batman v2 001 (1993-08)
02 - Batman v2 002 (1993-09)

I want the result to end up being
01 - Batman v2 001 - Life Lines Part 1 (1993-08)
02 - Batman v2 002 - Life Lines Part 2 (1993-09)

So in other words I want to keep the filenames in the first list but capture the dates from the second list and combine them to rename all the files in the list.

thanks


24/04-15 19:09
#2 : 27/04-15 08:40
Stefan
Stefan
Posts: 250
Reply to #1:

 
I would see it this way:
1.) find opening parenthesis from list 2 and and take everything right before. (Column C)
2.) take from list 1 everything after the hyphen. (Column D)
3.) find opening parenthesis from list 2 till the end (Column E)
4.) put all three parts together (Column F)

So one way would be to use a spreadsheet tool and do the math:
Column A: your first list
Column B: list 2
Column C: =LEFT(B1; FIND("(";B1)-2)
Column D: =RIGHT(A1; LEN(A1) - FIND("- ";A1)+2)
Column E: =RIGHT(B1; LEN(B1)-FIND("(";B1)+2)
Column F: =C1&D1&E1

5.) select columns C till F and copy the formulas down the rows.
6.) select Column F and save as plain text file:
01 - Batman v2 001 - Life Lines Part 1 (1993-08)
02 - Batman v2 002 - Life Lines Part 2 (1993-09)

7.) Use AdvancedRenamers List method to rename your files with list taken from Column F
(http://www.advancedrenamer.com/user_guide/metho d_list)


Works well with Spread32 v1.18 from Bye Design Ltd. (on Win7/64-Bit) too.
http://www.byedesign.co.uk/ v2.05 (June 27, 2012)
http://www.aplusfreeware.com/categories/busines s/spreadsheets.html (last freeware version 1.18)
http://www.portablefreeware.com/?id=561

 

----------
If this tool had saved you time, perhaps you want to donate an Dollar to Kim?
See http://www.advancedrenamer.com/download >>> [Donate] button.


27/04-15 08:40