[Lys]

I feel there's an easy solution to this, but I can't find it on my own, so I need a bit of help.

I have a column (genre) that I use as a hierarchical tag.
Some examples of data I have in this column are:

Fiction.Classics.English Literature
Fiction.Classics.French Literature
Fiction.Historical Novel.Country: India
Fiction.Fantasy

Then I have another column (genre_list) that separates genres using:

list_remove_duplicates(re($#genre, '\.', ','), ',')

And so far so good.


Now, I would like to have another column that excludes some items from genre_list.
The items I would like to remove are the ones matching the pattern: "xxxx Literature" and "Country: xxxx"

I know I can use list_difference to exclude values, but the list with the excluded values is compared term by term.
Is there a way to do so without having to list beforehand all occurrences of Country: xxxx, Xxxx Literature, but using the pattern?