Rename PDF Documents Using a Lookup Table
Introduction
Manually renaming multiple documents can be a slow process - the AutoSplit™ plug-in offers a handy tool for quickly renaming multiple documents at once, using a specific format. In this tutorial, we will demonstrate how a lookup table can be used to replace text in filenames based on PDF document content. This method offers a way to customize filenames using text that is not directly present in the document's content or filename. Typical applications include customizing filenames based on social security numbers, account numbers, or employee numbers etc. 
For example, the input documents used here are multiple single-page form W-2 statements. Each one contains a unique social security number (SSN) located in the same place on each page. The goal is to rename these documents so that they end in unique employee-specific codes - “AJ12/LA34/MS89/RC47”. This text is not located in the W-2s, so can’t be extracted as a filename component. Instead, we will extract a unique identifier (eg, SSNs), then use the lookup table method to replace it with the desired text. The lookup table used here contains a list of SSNs and their counterparts:
lookup table results
Note: the lookup table can be created manually within the plug-in's settings configuration screens, or prepared using an external application as CSV spreadsheet file and then loaded into the plug-in.
Batch Processing Support
Automate this operation with Acrobat's batch processing tool (Action Wizard) to process similar files using the same configuration with only one click.
Prerequisites
You need a copy of Adobe® Acrobat® along with the AutoSplit™ plug-in installed on your computer in order to use this tutorial. Both are available as trial versions.
Step 1 - Open the “Auto-Rename PDF Files” Menu
Start Adobe® Acrobat® and select “Plug-ins > Auto-Rename PDF Files…” from the main Acrobat menu.
open renaming dialog
Step 2 - Add Custom Filename Text
Press "Add..." to add a filename component.
add filename component
Choose a method for adding a filename component. Here, we will demonstrate how to add custom text. In our example, all filenames are going to start with the same prefix - W2-2021-.  We are going to use a "Custom Text" filenaming component to specify that. Select the "Custom Text..." option and press "Next >>".
use custom text
Enter the custom text that you wish to add to filenames. Here, we will add W2-2021-.
Press "OK" to proceed.
type custom text
Step 3 - Add Text From a Page Location
Next, we are going to extract text (SSN - social security number) from a specific location in the PDF document.  Press "Add..." to add a second filename component.
add filename component
Since this number always occurs at the same page location we are going to use "Text From Location" option and press "Next > >".
extract text
A dialog prompts the user to select a sample PDF to use to define an extraction area. If you already have a sample PDF file open in Adobe Acrobat, then this prompt is not going to be displayed. Press "OK" to proceed.
select sample PDF
Select a suitable sample file, and press "Open".
choose sample file
Define a page area to extract text from. For example, in the PDF documents to be renamed, the SSN is located in the same place on each page. Use the zoom and draw tools in the upper right corner of the dialog to draw a box around the text to be extracted.
Press "OK" to proceed.
draw search area
Step 4 - Create a Lookup Table
Now we need a way to replace SSN number in the filename with a corresponding code using a lookup table. Press "Add..." to add another filename component.
add filename component
Select the "Replace Text Using Lookup Table" option and press "Next > >". Note that this filename component performs search and replace on the current filename as it was created by previously applied filename components (Custom Text and Text From Location). At this time, filenames look like the following: W2-2021-123-45-6789.  Now we will add a lookup table to replace SSN numbers with other text.
add lookup table
Use this dialog to configure what text/pattern to search for, and what to replace it with. Enter a search expression or specific text to search for into "Find what:". Here, we have used \d{3}-\d{2}-\d{4} to search for social security numbers matching a "XXX-XX-XXXX" format. \d matches a single digit, {3/2/4} indicates the amount of digits - each one is separated by a dash (-).
The search expression will be used to search a "current" filename (after applying all previous filename components) to find a XXX-XX-XXXX pattern and replace it with a value from the lookup table. If there is no matching text in the lookup table, then no replacement is performed. Check "Replace missing values with" option and type a default value to use in case there is no match in the lookup table. For example, if SSN number is not listed in the lookup table, and this option is checked, then a default value ("MISSING VALUE") will be used for the replacement creating W2-2021-MISSING VALUE.pdf filename.
type search pattern
Next, it's possible to either manually type lookup entries, or load a pre-saved *.csv lookup table (see step 5). Type comma-separated lookup entries and replacement values in the box below, one-per-line. The example shown below would replace the "123-45-6789" SSN in a filename, with "AJ12".
type lookup entries
Step 5 - Load a Lookup Table from CSV Text File
Optionally, use "Load from text file..." button to load a pre-configured lookup table from CSV text file (comma-separated values). Please note that this operation only loads lookup table into the settings. If you want change the CSV file later, it is not going to have any effect on the loaded settings. If you want to update lookup table using edited CSV file, then repeat this step again.
load text file
Locate and select the desired *.csv text file, then press "Open".
open lookup table
The table entries will have been loaded - press "OK" to proceed.
confirm table entries
Step 6 - Confirm/Save Renaming Options
Optionally use the "Save Settings..." button to save this configuration as a *.docren settings file for future re-use. This can be loaded via the "Load Settings..." button.
Click "OK" to use these settings to rename files.
save/confirm settings
Step 7 - Add Files for Renaming
Press “Add Files…” in the “Select Input Files” dialog to select files that need to be renamed. Consider also making backup copies of the input files before processing.
add input files
Select PDF files that need to be renamed and click "Open" once done. Note that files from multiple folders can be added with repeated use of the "Add Files..." button.
select files to rename
Selected PDF files will be listed in the "Select Input Files" dialog. Press "OK" once all necessary files have been selected.
rename selected files
Step 8 - Review and Confirm New Filenames
The software will process input files without renaming them yet, and present "computed" file names in the "Review and Confirm New Filenames" dialog. The selected files have had new filenames generated for them - the SSN's have been successfully extracted, then replaced with the values in the lookup table.
Note that no files have actually been renamed at this step.
Review the generated file names and edit them manually by double-clicking on an output filename cell.
Press “Rename” to confirm the renaming process.
review new filenames
Check the renaming statistics. Click “OK” to open a processing report.
open a processing report
The processing report shows detailed information on how many files have been renamed or failed, along with input/output filenames for each document.
Optionally save this report by pressing the "Save..." button. Click "Close" to close it.
save/close the report
Open the relevant folder to inspect the new filenames. Here, they now follow the "W2-2021-XXXX" format:
inspect the results
You can find more AutoSplit tutorials here.