#1 : 08/02-18 13:57
I have a question about renaming from 1 source file to multi files.
I have a CSV file with the original name and also a the needed file names.
I have one file named: sourcefile-01.jpg
I want that file into multi files:
Is there a way to do this?
#2 : 08/02-18 15:34
Reply to #1:
That's a COPY job, not a RENAME! - But as you have that CSV file, it would be pretty simple to import that file into a spread-sheet, insert a column between the filename pair, and insert a column at the beginning. Then by typing into Row 1, the extra info need for a batch file, and replicating it down the sheet, you could generate the data needed to make the batch file to do the job. Copy ALL the Columns/Rows from the spread-sheet into a reasonable Programmer's Notepad equivalent (I use Metpad but there are many), replace all 'tabs' with 'nulls' then save as RAW TEXT - a '.txt' file. Rename that txt file, changing the extension to '.bat', OK the warnings from Explorer, then double-click the new .bat file - as long as that .bat file is in the same folder as your original sourcefile-01.jpg, then the whole series will be created.
Example - CSV is:
Import to spread-sheet, insert column before and after 'sourcefile-01.jpg':
| |sourcefile-01.jpg| |123.jpg
| |sourcefile-01.jpg| |456.jpg
| |sourcefile-01.jpg| |789.jpg
('| |' stands for empty column.)
Add to row 1 as follows:
COPY "|sourcefile-01.jpg|" "|123.jpg|"| ... The '|' marks columns.
Replicate Columns 1,2,5 as required by your list.
Copy/Paste into 'MetaPad' or such, and you'll get:
COPY " > sourcefile-01.jpg > " " > 123.jpg > "
COPY " > sourcefile-01.jpg > " " > 456.jpg > "
COPY " > sourcefile-01.jpg > " " > 789.jpg > "
Replace all 'tabs with 'nulls' to get a usable batch file:
COPY "sourcefile-01.jpg" "123.jpg"
COPY "sourcefile-01.jpg" "456.jpg"
COPY "sourcefile-01.jpg" "789.jpg"
And that will do the job. Sure, you could spend ages trying to work out a 'FOR ... tokens ... ' loop to read the csv file and do the same job, but I have found that the spread-sheet method is usually faster overall. - Easier to repeat with a different csv and/or basefile, too!
Hope this helps.
If this brilliant little tool has saved you time, or helped get your files in a better order, or just cleaned-up the crazy names from downloaded files, maybe you could donate a Dollar or Ten to Kim?
#3 : 08/02-18 15:57
Reply to #2:
thank you, this works very well!!!