Custom folder column based on segment of filename or metadata

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)