Removing AlbumArtist from Artist Field

[Capa]

Hi.
New here!
I was looking for a way to remove AlbumArtist field from the artist field and leaving the feature artist names.

Example

Artist
Abandon All Ships, A Game, Jonny

AlbumArtist
Abandon All Ships

And also if possible to make the last , become a &.

Thanks in advance.

[ohrenkino]

To move the data you could use an action of the type "Guess value" like
Source: %artist%
Pattern: %albumartist%, %artist%

And to replace the remaining comma with an ampersand, use an action of the type "Replace".

[Capa]

Say there are two or three comma's

X, Y, Z
Is there a way to make just the last coma a &

[ohrenkino]

see here:

How to batch replace the last comma with ampersand (&) character.

In artist tag, I want to batch replace the last comma with ampersand (&) character. e.g. if artist tag is "Artist A, Artist B, Artist C" result should be "Artist A, Artist B & Artist C". and if "Artist A, Artist B" result should be "Artist A & Artist B". How to do it by action? May I get the regular expression replace syntax for the same. Thanks...