Maybe someone else once opened a thread similar to this one, but I have actually searched the forum and couldn't solve my problem.
I'm trying to eliminate duplicate artists from the %artist% field. Suppose I have in this field "Frank Sinatra, Frank Sinatra & Mia Farrow" and would like to replace it with just "Frank Sinatra & Mia Farrow".
I have tried %dummy%, %artist% but it leaves me the field like this ",Frank Sinatra, Frank Sinatra & Mia Farrow".
The attempt to split the field %artist% with an action of the type "Guess value"
Source: %artist%
Pattern: %dummy%, %artist%
gave the result "Frank Sinatra & Mia Farrow", whereas the original was "Frank Sinatra, Frank Sinatra & Mia Farrow"
Is there a possibility that if the artist is not the same as the next one, he will not remove the artist or change it?
I'm having problems changing several music pieces because sometimes it's the same format as %artist%, %artist% but with a different artist, but also eliminated.
I would filter for those that should be treated: NOT "$strstr($mid(%artist%,$strstr(%artist%,', '),$len(%artist%)),$left(%artist%,$sub($strstr(%artist%,','),1)))" IS 0