I've gone a bit cross-eyed trying to work out this RegEx. Here is an example of what I'm hoping to do:
TITLE: That's Just How It Is (feat. Ty Dolla $ign, Leon Thomas & The-Dream)
ARTIST: A$AP Rocky
I would like the title to remain unchanged but I would like artist to change to:
ARTIST: A$AP Rocky\\Ty Dolla $ign\\Leon Thomas\\The-Dream
The closest I have come is this:
ACTION: Guess Values
SOURCE FORMAT: $regexp(%artist% - %title%,(.*) - (.*) \(feat. (.*)\),$1\\\\$3)
GUESSING PATTERN: %artist%
which gives:
ARTIST: A$AP Rocky\\Ty Dolla $ign, Leon Thomas & The-Dream
How can I split $3 into the individual items and apply the \\\\ between each?
For further use it should also account for the fact that sometimes there's only a single artist featured ex: (feat. Ty Dolla $ign). If there are exactly two featured artists it is often with an ampersand only and no commas ex: (feat. Ty Dolla $ign & The-Dream). Three or more artists is as the original example, comma separated until the final two which are ampersand separated.
Any help greatly appreciated!
edit tldr:
BEFORE
TITLE: That's Just How It Is (feat. Ty Dolla $ign, Leon Thomas & The-Dream)
ARTIST: A$AP Rocky
AFTER
TITLE: That's Just How It Is (feat. Ty Dolla $ign, Leon Thomas & The-Dream)
ARTIST: A$AP Rocky\\Ty Dolla $ign\\Leon Thomas\\The-Dream