INTERACT FORUM
More => Old Versions => JRiver Media Center 29 for Mac => Topic started by: HaWi on May 04, 2022, 01:50:54 pm
-
My [Soloists] field contains <instrument><space><–><space><soloist name> example: Violin – Gil Shaham
Could someone help me with a regex expression to extract the <soloist name> from this, please?
Many thanks for any help!
Hans
-
Assuming [Soloists] contains only 1 item (ie, not a list):
regex([Soloists],/#-\s*(.+)#/,1)
If it's a list this should work:
regex([Soloists],/#-\s*([^;$]+)#/,-2)
-
I have officially been unseated as the Regex Champ of JRiver.
Long live Zybex!
Brian.
-
Assuming [Soloists] contains only 1 item (ie, not a list):
regex([Soloists],/#-\s*(.+)#/,1)
If it's a list this should work:
regex([Soloists],/#-\s*([^;$]+)#/,-2)
Thank you so much Zybex! I'll try this out right away.
EDIT:
I tried both versions but unfortunately got a blank in both, wiith single Soloist and with lists. Could this be because the - is an em-dash (–), like <Option>-?
EDIT2:
In [Soloists], I am replacing all regular dashes (hyphened names) with spaces and all em-dashes with regular dashes. Preliminary evidence suggests that will yield the desired results with the regex expressions. Gonna take a while, MC is grinding through >15K tracks right now for the Classical part. Will do the non-classical part if this works out as expected.
Many thanks again, Zybex!
-
Well yesterday I was looking at your dash and thinking "is he using em-dash? Oh well, who cares" ;D
Here's one that works with both - take care to copy/paste it, that's an em-dash in there:
regex([_tmp],/#[-–]\s*([^;$]+)#/,-2)
There's a standard regex class that would capture all kinds of dashes but MC doesn't seem to support named classes. It would be so:
regex([_tmp],/#\p{Pd}\s*([^;$]+)#/,-2)
EDIT: If you want to allow hyphened names and only split on "space+[em]dash+space", you can use this one:
regex([_tmp],/# [-–] ([^;$]+)#/,-2)
-
Well yesterday I was looking at your dash and thinking "is he using em-dash? Oh well, who cares" ;D
Here's one that works with both - take care to copy/paste it, that's an em-dash in there:
regex([_tmp],/#[-–]\s*([^;$]+)#/,-2)
There's a standard regex class that would capture all kinds of dashes but MC doesn't seem to support named classes. It would be so:
regex([_tmp],/#\p{Pd}\s*([^;$]+)#/,-2)
EDIT: If you want to allow hyphened names and only split on "space+[em]dash+space", you can use this one:
regex([_tmp],/# [-–] ([^;$]+)#/,-2)
Wow, this is amazing. I am bowing in front of the master. Thank you so much, Zybex!
EDIT: naturally, needed to replace the [_tmp] with [Soloists] (you are testing me ;D ) and it works as a charm. Thanks again so much, Zybex!
-
Wow, this is amazing. I am bowing in front of the master. Thank you so much, Zybex!
EDIT: naturally, needed to replace the [_tmp] with [Soloists] (you are testing me ;D ) and it works as a charm. Thanks again so much, Zybex!
Oops ::)
That's from testing with Zelda using a temp field, I forgot to edit it after pasting here.
You're welcome.
-
Oops ::)
That's from testing with Zelda using a temp field, I forgot to edit it after pasting here.
You're welcome.
For a split second there I thought it was some high level regex magic ::) but then it clicked that it was a test field.
I really appreciate your help