Replace Feat Artist Artist1 Artist2

Hi Everybody:
I Need an Action for This:

Artist, Artist1, Artist2, Artist3
to
Artist Feat Artist1 & Artist2 & Artist3

Help me Please.. Thanks

Create an action of the type "Format value"
Format string: $regexp('Artist, Artist1, Artist2, Artist3','(.*?), (.*)',$1 feat $2)
and then an action of the type "Replace"
Search string: ,
Replace string: &
But does it make sense?
What about Artists like
Dave Dee, Dozy, Beaky, Mick & Tich
Earth, Wind & Fire
Emerson, Lake and Palmer
Bell, Book & Candle
Blood, Sweat & Tears
I Will, I swear
Portugal, The Man

Thanks Ohrenkino.

Regex works but literally changes the artist's name to the word Artist.
In relation to the artists you name I will not use the function with them.

As you did not mention in which field you wanted to change that string, I assumed that you knew what you were doing.
You would have to substitute
'Artist, Artist1, Artist2, Artist3'
with the correct field variable name

The field is an artist.
Would the function look like this?

$regexp('%artist%,'(.?), (.)',$1 feat $2)

The Result is only the word: %artist%
:roll_eyes:

Too few apostrophes or too many.

should be
$regexp(%artist%,'(. *?), (.* )',$1 feat $2)

1 Like

Great! Thanks :grinning: