#1 : 24/04-15 19:09 David
Posts: 64
|
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 |
#2 : 27/04-15 08:40 Stefan
Posts: 274
|
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 |