building a genre custom column from tags

[meghane_e]

I'm trying to use the tags that get automatically imported to build my #genre column based on other columns (tags). It's slow going, but with over 8000 books and over a couple of dozen new ones added each week, worth it to figure out. But I'm stuck on a couple of things. First is a regex question at the bottom. Second, is there a known/better way for setting up a #genre column already? There was a plugin (DeriveGenre) that's no longer up.

So my custom column is set up like this right now:

program: 
build_genre = list_re_group(field('tag'), ', ', '', '(.*)romance(.*)', '', 'Love & Romance ', ''); 
build_genre = list_re_group(build_genre, ', ', '', '(.*)fantasy(.*)', '', 'Fantasy ', ''); 
build_genre = list_re_group(build_genre, ', ', '', '(.*)crime(.*)|(.*)mystery(.*)', '', 'Crime & Mystery ', '')

One of my tags is "Private Investigators (1+)" so I
I tried in build_genre = list_re_group(build_genre, ', ', '', '(.*)investigat(.*)', '', 'Crime & Mystery ', '')
but it doesn't like that. When I switched it to build_genre = list_re_group(build_genre, ', ', '', '(.*)privat(.*)', '', 'Crime & Mystery ', '') it did take it. I tried '^(.*)investigat(.*)' and a couple of other things but still not getting it.
Thank you in advanced!

[DaltonST]

The Derive Genres plugin was redesigned and then incorporated into the CALM and Q&S plugins. CALM is easier if DG is all you want.

[meghane_e]

@ Dalton, I appreciate the work put in on CALM and I tried it a couple of times, but the documentation and forum help was too confusing/scattered for me and I'm not sure it would ultimately give me my desired result. Thank you though.

@all, for now, I'd like to get the specific regex working for copying/replacing words in a list like 'private investigator', 'private investigators', 'Private Investigator (+1)'.

General goal:
Basically my books come from multiple sources but mainly amazon. Genre metadata is not being filled even though I think I activated it for Goodreads (separate thing for more exploring). The publishers and sellers just dump everything into the 'tags' field anyway.

I have 2 custom columns for the task. One column is a tag-browser set of preferred genre cagegories's that I can also edit manually (#genre). and the other a composite column I'm trying to map commonly-used tags to (#genre_from_tags). My #genre column is a 'text, as tags' format and #genre_from_tags is built from other columns using the template langauge (GPL).

[meghane_e]

Resolved - For other noobs looking for some help:

My problem was caused by the ending parenthetical expression in a tag. The expression (^.*)((investig)(.+$) seems to work to deal with variations that include an expression with a partial word and a parenthetical expression at the end, like '(+1)' or '(anything)'.

This following expression (^.*)((investig)(.+$)|(^.*)(detect)(.+$)) maps multiple partials to a genre:

list_re_group(build_genre, ', ', '', '(^.*)((investig)(.+$)|(^.*)(detect)(.+$))', '', 'Crime & Mystery ', '');