Merge Filenames From Two Folders

SixthSense · Yesterday 16:11

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 (Yesterday 16:35)

den4b · Yesterday 20:23

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.

SixthSense · Yesterday 20:45

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.

den4b Forum

#1 Yesterday 16:11

Merge Filenames From Two Folders

#2 Yesterday 20:23

Re: Merge Filenames From Two Folders

#3 Yesterday 20:45

Re: Merge Filenames From Two Folders

Board footer