More > JRiver Media Center 21 for Windows

Songs with feat. (featuring) best practices

<< < (5/5)

connersw:

--- Quote from: blgentry on March 17, 2016, 08:48:19 am ---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.

--- End quote ---

This is awesome.  I thought about requesting something similar, but I didn't want to get greedy.  Also, I was worried it would mess with song titles that use & or and in the actual Name (Ex Me and My Uncle ft. her, him and she).  Doing it your way doesn't seem to cause a problem.

I've updated your expression to make it a little uglier so that it now includes "and".

--- Code: ---replace(replace(replace(replace(replace(regex([Name],/#(.+)\s+\(*(featuring|feat|ft)\.*\s+([^\)]+)\)*$#/,-1,0)[R3],/,,;),&,;),and,;),/ ;,;),/; ,;)
--- End code ---

I've updated the guide above with the new expression.  I've also changed Note 3 since it should separate most multiple Featuring Artists correctly with the rare exceptions of some band names. 

justsomeguy:
Brian you are the man! Wish i could buy you a beer or a case of beer. Just tested it real quick on a small set of songs with various combinations of , and & as well as "and" (thanks connersw) and it works great.

Thanks Brian for your work and willingness to help and thanks for the guide connersw.

blgentry:

--- Quote from: justsomeguy on March 17, 2016, 01:47:56 pm ---Brian you are the man! Wish i could buy you a beer or a case of beer.

--- End quote ---

That's nice of you to say.  Should we ever meet, you can buy me one beer for each letter in FEAT.  Bonus points if the beer's name starts with each of those letters!

I'm happy to help with this stuff, but it's really nice when someone appreciates it.  :)

Brian.

connersw:

--- Quote from: blgentry on March 12, 2016, 09:48:40 am ---This is ugly because parenthesis are special characters in regex, so you have to escape them with backslashes first, like:

\(
\)


--- End quote ---

Brian:  I'm stuck again.  I tried to hack my way through it, but I'm having issues with special characters again.

I want to modify the expression so that it works if either parenthesis or brackets are used to delineate the Feat. portion, and I know brackets are special characters as well. 

For example, I would like it to work when [Name] = Song (feat. TEST) or [Name] = Song [feat. TEST]

So far, I've only been able to get to work on one or the other, but not both.

Fuzzysocks:

--- Quote from: connersw on November 14, 2016, 09:35:19 am ---I've only been able to get to work on one or the other, but not both.

--- End quote ---

Anyone ever figure out an answer for this one? Running into the same problem. great script though, Thanks Brian!

Navigation

[0] Message Index

[*] Previous page