The texts contain a different even number of words.
I would like to eliminate the obvious redundancy in the text.
After correction, I would like to get the following:
in detail, I am not shure how to deal with this.
--.--
Another idea is to find the beginning of the redundant second part of the string and split COPYRIGHT in 2 values and delete the second one. But stil have to build an expression that scans the string ....
There is no logical link between GENRE and COPYRIGHT.
In COPYRIGHT you will often find
a) the holder of the copyright
b) the representative of the trademark
I use COPYRIGHT and use it synonymously with the value of PUBLISHER.
My goal here is to reduce or merge to one value.
The regular expression deals with the contents of GENRE as you can see in
To make that work with COPYRIGHT or if you like PUBLISHER, you have to replace %genre% with the fieldname that you want to treat, so it should become ...$regexp($regexp(%copyright%,'^(\s+;...
or ...$regexp($regexp(%publisher%,'^(\s+;...
or whatever field you want to treat.