More > JRiver Media Center 21 for Windows
Songs with feat. (featuring) best practices
justsomeguy:
blgentry , wow that is great. This has always been in the back of my head but seemed beyond my understanding of MC expressions to accomplish. This works!
I have one question... I have lots of track names with multiple featured artists separated by commas. You've already done a lot but is it possible to separate those out?
for example, "track name (feat artist2, artist3, artist4)"
I also have a few instances like "track name (feat artist2, artist3 & artist4)" but not many.
You've already made life exponentially easier with what you've already done, so no worries if you don't want to or there isn't a way to cover those other circumstances.
blgentry:
--- Quote from: justsomeguy on March 17, 2016, 01:39:09 am ---I have one question... I have lots of track names with multiple featured artists separated by commas. You've already done a lot but is it possible to separate those out?
for example, "track name (feat artist2, artist3, artist4)"
I also have a few instances like "track name (feat artist2, artist3 & artist4)" but not many.
--- End quote ---
So do you want the output of this to look like this?
artist2;artist3;artist4
If that's what you want, here's a really ugly, long expression that converts commas (,) and ampersands (&) to semicolons and removes extraneous spaces after. All tacked on to the original regex.
--- Code: ---replace(replace(replace(replace(regex([Name],/#(.+)\s+\(*(featuring|feat|ft)\.*\s+([^\)]+)\)*$#/,-1,0)[R3],/,,;),&,;),/ ;,;),/; ,;)
--- End code ---
Give it a try in an expression column and see if it does what you want, and let me know. :)
Brian.
ferday:
I suspect he hasn't run the code yet to see, because you are already running a greedy search it should already find multiple ft. In the string
But your new code has me thinking about some cleaning for better or worse. Thanks for the headache inducing regex blgentry :)
blgentry:
--- Quote from: ferday on March 17, 2016, 08:51:58 am ---I suspect he hasn't run the code yet to see, because you are already running a greedy search it should already find multiple ft. In the string
--- End quote ---
It does. It just outputs them all together with commas, ampersands, etc all intact. My add on "replace" code just eats the separators and turns them into semicolons so they can be used in a list type field as multiple values.
--- Quote ---But your new code has me thinking about some cleaning for better or worse. Thanks for the headache inducing regex blgentry :)
--- End quote ---
Any time. :P
Brian.
221bBS:
I use Musicbrainz's Picard to tag all my music. They have a few fields they use for artists (artist, artists, artistsort).
Artist=write the artist as it is on the release (ABC feat. XYZ)
Artists=semi-colon list of all the artist in Artist (ABC; XYZ)
with these two fields, Album Artist, and the option to standardize artist names in Picard, I'm able to do the following with the help of expressions.
I'm pretty happy with how I'm able to mange my artists.
Navigation
[0] Message Index
[#] Next page
[*] Previous page
Go to full version