I have searched through the forum, and tried a number of potential options, but have not quite found the right mix of actions for my needs. Some of what I found works, but only partially. I need a bit of help tweeking this code to the next level.
What I have:
Artist: David Guetta Feat. Sam Martin
Title: Lovers On The Sun
I need:
Artist: David Guetta
Title: Lovers On The Sun (Feat. Sam Martin)
This is the code I found, and it works, but just not the way I want it to. Now I want to ensure that the featured artist(s) appear in parenthesis, and any extra spaces are deleted if I have not accounted for those too.
1st FormatFormat Value
Field: TITLE
Format string: %title% feat $mid(%artist%,$add($strstr($lower(%artist%),' feat'),6),$len(%artist%))
2nd FormatFormat Value
Field: ARTIST
$left(%artist%,$add($strstr($lower(%artist%), feat),-1))
Just tried that, and it did not work. The artist line did not change at all, and the title line simply added the raw text of "(Feat. )". The results were:
Before:
Artist: Calvin Harris Feat. Tinie Tempah
Title: Drinking From The Bottle
After:
Artist: Calvin Harris Feat. Tinie Tempah
Title: Drinking From The Bottle (Feat. )
Your screenshot shows:
Guess values "artist": ....
but should show
Guess values %artist%: ...
That is because in the Guess-values-action you did not select "artist" from the menu but wrote manually "artist" for the source. Selecting from the list will write %artist% which you can write manually too.
However I do have a question, I apparently must review the album for ONLY those tracks that have a featured artist, otherwise I end up with a second issue. If I DO select the entire album rather than picking each track w/featured artist, then this happens when there is NOT a featured artist. Is it possible to have this based on ONLY when there is a featured artist/artists?