How do I rename files dumped from a MasterFile briefcase?
There are three parts to renaming files dumped from a MasterFile briefcase
- Dump the files to disk.
- Modify the CSV file that was created during the dump for use by BulkRename Utility. (BulkRename Utility is a very useful free utility that is supported by donations. Download it at http://www.bulkrenameutility.com).
- Rename the files with BRU.
Place the CSV file in Excel using Excel's Data tab
Note there are many columns in the CSV file. We only need two for our purposes and will delete the rest.
Note that CSV files can not simply be opened in Excel due to Excel data conversion errors. You can learn more about placing files in Excel by following these instructions.
Column B, DP_ORIGINAL_LOCATION_K, will either contain
- just the file name, which can be used to rename the dumped files, or
- a full path and filename in which case the filename needs to be extracted from the path using the formula =RIGHT("\"&B2,LEN("\"&B2)-FIND("|||",SUBSTITUTE("\"&B2,"\","|||",LEN("\"&B2)-LEN(SUBSTITUTE("\"&B2,"\",""))))) pasted into each cell of column C.
Modify the CSV file for BulkRename Utility
- Open the CSV file in a text editor like Notepad or Notepad++. (Notepad++ is a free, advanced test editor with very useful features, including the ability to display very long lines, supported by donations. Download it at http://notepad-plus-plus.org.)
- Replace all instances of ,+==+, (you must include both commas) with | (| is the vertical bar usually above the \ symbol on the keyboard).
As you can see, ,+==+, has been replaced with |
Save the CSV file which is now ready to be used to rename the files dumped from the MasterFile briefcase.
Rename the files using BulkRename Utility
Click Rename to apply the new names.