GROUP BY with parts of filename?

[wowbagger]

Version 11.5.1 allows this.
This post should get you started Custom Column - "Custom Text Columns"