In some songs I have redundant artist information that I would like to correct.
For example
> Victoria Monét, Earth, Wind & Fire, Hazel Monét; Earth, Wind & Fire & Hazel Monét Earth, Wind & Fire, Hazel Monét; Earth, Wind & Fire
What I like to get is > Victoria Monét; Earth, Wind & Fire; Hazel Monét Earth, Wind & Fire, Hazel Monét
How can I correct this and similar with an rule based action (i.e. REPLACE)?
Best would be an action that identifies and corrects redundant artist information in general.
This is basically true but does not check in any way if the part after the ; is the same as the part in front of the ;
The OP only wants to remove redundant (identical) information that occurs twice.