getmusicbee.com

Support => Questions => Topic started by: Johan_A_M on November 18, 2021, 08:25:43 PM

Title: How to use $First and $RSplit with multiple separators?
Post by: Johan_A_M on November 18, 2021, 08:25:43 PM

Hi!

I'm trying to extract the surname from the <Composer> to create folders. Right now, this is my formula:

• <Genre> •\· · $First($RSplit(<Composer>," ",1)) · ·\

, but I ran into problems if there are sometimes two composers separated by a semi-colon.
If the <Composer> for example is

Tomaso Albinoni; Remo Giazotto

how would I use Musicbee's functions to only extract Albinoni (and also if there were even more names, or some composer with more names than two, like all Russian)? As far as I understand, I can't use $Or inside anything but $If?


Edit: Sorry, posted in wrong forum.

Title: Re: How to use $First and $RSplit with multiple separators?
Post by: hiccup on November 18, 2021, 08:54:03 PM

Does this do what you are looking for?:

$If($Contains(<Composer>,;)="T",$RSplit($Split(<Composer>,;,1)," ",1),$RSplit(<Composer>," ",1))

Title: Re: How to use $First and $RSplit with multiple separators?
Post by: Johan_A_M on November 18, 2021, 09:08:00 PM

Quote from: hiccup on November 18, 2021, 08:54:03 PM

Does this do what you are looking for?:

$If($Contains(<Composer>,;)="T",$RSplit($Split(<Composer>,;,1)," ",1),$RSplit(<Composer>," ",1))

Oh yes it does! Thanks hiccup, you saved my day!