#1 2025-04-02 16:11

SixthSense
Member
Registered: 2025-04-02
Posts: 3

Merge Filenames From Two Folders

Q: I have two folders with filenames that start the same, but second folder has extra naming text which I want to copy to first folder, so both files have same filename.

Example:
----------

Folder One filename:
0330_11_001

Folder Two filename:
0330_11_001_B - Docking Plan


I want all the files in Folder One to have the extra filename text from Folder Two. Each file has different additional text:

Filename One  v   Filename Two
1201_11_005  v   1201_11_005_D  - General Construction Plan Superster - Main Sections - Fr 62 -Fr 80
2700_11_001  v   2700_11_001_C - Windows & Portholes Arrangement
and so forth.

Thanks.

Last edited by SixthSense (2025-04-02 16:35)

Offline

#2 2025-04-02 20:23

den4b
Administrator
From: den4b.com
Registered: 2006-04-06
Posts: 3,474

Re: Merge Filenames From Two Folders

There are multiple ways of achieving this with different levels of complexity and nuances.

The easiest way is probably with the User Input rule, but it assumes the files between the two folders are mapped 1:1 exactly.

1. New renaming project, no rules.
2. Add files from the "full names" folder.
3. Sort by the Name column.
4. Export menu » Export new names to clipboard.
5. Remove all files.
6. Add files from the "short names" folder.
7. Sort by the Name column.
8. Add a User Input rule and paste the list of names from clipboard.

Offline

#3 2025-04-02 20:45

SixthSense
Member
Registered: 2025-04-02
Posts: 3

Re: Merge Filenames From Two Folders

Thanks, unfortunately each folder is not an exact duplicate - there are a few extra files in each folder.

I appreciate you taking the time - I will keep the above solution in mind for the future.

Offline

#4 2025-04-04 19:50

den4b
Administrator
From: den4b.com
Registered: 2006-04-06
Posts: 3,474

Re: Merge Filenames From Two Folders

SixthSense wrote:

unfortunately each folder is not an exact duplicate - there are a few extra files in each folder.

Depending on the number of those extra files, you could actually remove those extra files from the list to make that renaming plan work.

Alternatively, you can try something like this:

1. New renaming project, no rules.
2. Add files from the "full names" folder.
3. Add a rule to delete the extra part of the filename to match the short filenames.
4. Export menu » Export all columns to clipboard.
5. Open LibreOffice Calc (or Microsoft Excel), paste the contents from the clipboard.
6. Remove all columns except for "Name" and "New Name", which should correspond to full and short filenames.
7. Swap the two columns around so that the first column has short filenames and the second column has full filenames.
8. Save as a CSV file into your "short names" folder.
9. New renaming project, no rules, no files.
10. Export menu » Import file paths and new names.
11. Rename.

Soon there will be a new Mapping rule added to ReNamer which will simply this procedure.

Offline

#5 2025-04-04 21:34

SixthSense
Member
Registered: 2025-04-02
Posts: 3

Re: Merge Filenames From Two Folders

I did it!
Thanks - not the easiest thing to use, but only because not my area of expertise!
Look forward to the new Mapping rule, hopefully easy to use.

NB: Great program and the help is only helpful if you are clued up. Suggest adding some examples on each rule/function to aid people like me!

Thanks.

Offline

Board footer

Powered by FluxBB