What is the Classifier?
The Classifier is a spreadsheet-based tool for renaming files to ZDDC naming conventions. It reads a folder of files and presents them in an editable grid where you can set tracking number, revision, status, and title — then saves the renamed files back to disk.
Getting Started
- Click Use Local Directory to open a folder containing files to rename.
- The folder tree on the left shows all sub-folders. Click a folder to load its files.
- Edit cells in the spreadsheet to set the new filename components.
- Click Save All (or save individual rows) to rename the files on disk.
Folder Tree
- Multi-select
- Hold Ctrl and click to select multiple folders. Hold Shift to select a range. Files from all selected folders are shown together.
- Hide Compliant
- Hides folders where all files already have valid ZDDC names, letting you focus on work remaining.
- Auto-scroll
- When enabled, the folder tree scrolls to highlight the folder containing the row you are editing.
Spreadsheet Editing
- Direct cell editing
- Click any cell in the New Filename, Tracking, Rev, Status, or Title columns to edit it. Press Enter to confirm, Escape to cancel.
- RC References
- Type a formula like
=R[-1]C to copy the value from the cell one row above in the same column — similar to Excel relative references.
- Regex capture groups
- Type a formula like
=RE(RC[-3], "(\w+)-(\d+)", "$1") to extract a pattern from another cell using a regular expression.
- Validation
- Cells are validated automatically. Invalid values are highlighted in red. The New Filename column shows the composed result.
- Column Filters
- Each column header has a filter input. Supported syntax:
term
- Contains "term" (case-insensitive)
!term
- Does not contain "term"
^term
- Starts with "term"
term$
- Ends with "term"
a b
- Matches both (AND)
a | b
- Matches either (OR)
^IFA | ^IFB
- Starts with IFA or IFB
!^~
- Does not start with ~ (excludes drafts)
el.*spc
- Regex: contains "el" followed by "spc" (use
. for any char, .* for any sequence)
[ei]fa
- Regex character class: matches "efa" or "ifa"
Saving Files
- Save All
- Renames all modified files in one operation. Confirms before proceeding.
- Cancel All
- Reverts all unsaved edits back to the original filenames.
- SHA256
- Enable to compute a cryptographic hash of each file. Use Export Hashes to save a
sha256sum-compatible file.
ZDDC Filename Format
The required format is:
TRACKINGNUMBER_REVISION (STATUS) - Title.ext
Example: 123456-EL-SPC-2623_A (IFR) - Electrical Specification.pdf
Valid statuses: IFA, IFB, IFC, IFD, IFI, IFP, IFR, IFU, REC, RSA, RSB, RSC, RSD, RSI, ---