Bulk Renaming files (and moving into subfolderds) for upload into Revver
Rough steps:
Export file list into a spreadsheet
- Open Powershell and navigate to the directory
-
Dir | Export-CSV content.csv -NoTypeInformation
- Open in a spreadsheet and remove the unneeded columns
- Do a find and replace to rename any files
- The left column should have the original file name and the right column should have the new file name
Download Bulk Rename Utility
- Download Bulk Rename Utility - https://www.bulkrenameutility.co.uk/Download.php
- Most basic stuff can be done here. Folders and subfolders should be done in f2
Download f2 Renamer
- Download f2 - https://github.com/ayoisaiah/f2
- Navigate to the area you need to rename and add files to subfolders. The following example uses underscores to specify where the subfolders go.
-
f2 -f '([a-zA-Z0-9-]+)_([a-zA-Z0-9-]+)_([a-zA-Z0-9-]+)*.txt$' -r '$1/$2/$3{ext}'
-
- The command above just does a test run to check. You need to add -e (or something) at the end to execute.