I need some help with regex, or maybe templates if regex isn't the best way. I know nothing about Python and am just getting into Regex because of Calibre.
Trying to add some metadata to columns during import.
I have a magazine collection with 2 levels of folders, 1 root level and 1 sub level folder with all the magazines from that year. The top level is the magazine name such as "Make", then underneath the year folder(s) with the issues inside for each year. Each issue is named with the month and year, such as: December 2018.pdf
What I have done is just pulled out all the magazine files and placed them flat in another folder. I am looking to Parse the filename for the month and year and place that data into .
Tried A lot of regex things and have got as far as matching some data with various regex experiments. Everything just goes into the Title field on the regex test page. How come something like this doesn't populate with the year ?
(?P[^_0-9-]+)
I understand as far as parsing the filename to find a match. I am at a loss as to the high level next steps as well.
Assuming I have found a matching filename, do I need to "capture" the data, or is it captured when parsed ?
I am thinking of doing a column with just the year, and trying the month Year and using series to sort each mag chronologically.
maybe just putting each item into it's own column.
Any help would be appreciated.

