Custom folder column based on segment of filename or metadata

I'm a photographer and I'd like to have a "job name" identifier incorporated into my images. The easiest would be to put it into the filenames, such as "Smith-Joe-A8K2-220717-1234" where "A8K2" is the identifier. The digits that follow this identifier would always be the same quantity so it's possible to always indicates the 4-character group prior to the last 12 characters is the job identifier.
One purpose of this identifier is to then be able to use DO lister windows to be sorted by this identifier but I'm not sure there's a "custom column" option with which to use this information.
Any thoughts? Thanks!

This can be done via scripting. There are a number of scripts on the forum that can create columns using regex to manipulate the filename. For example:

and

(and others)