Print

Please login or register.
1 Hour 1 Day 1 Week 1 Month Forever
Login with username, password and session length

[HaWi]

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

[zybex]

Assuming [Soloists] contains only 1 item (ie, not a list):

Code: [Select]

regex([Soloists],/#-\s*(.+)#/,1)
If it's a list this should work:

Code: [Select]

regex([Soloists],/#-\s*([^;$]+)#/,-2)

[blgentry]

I have officially been unseated as the Regex Champ of JRiver.

Long live Zybex!

Brian.

[HaWi]

Assuming [Soloists] contains only 1 item (ie, not a list):

Code: [Select]

regex([Soloists],/#-\s*(.+)#/,1)
If it's a list this should work:

Code: [Select]

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!

[zybex]

Well yesterday I was looking at your dash and thinking "is he using em-dash? Oh well, who cares" 
Here's one that works with both - take care to copy/paste it, that's an em-dash in there:

Code: [Select]

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:

Code: [Select]

regex([_tmp],/# [-–] ([^;$]+)#/,-2)

[HaWi]

Well yesterday I was looking at your dash and thinking "is he using em-dash? Oh well, who cares" 
Here's one that works with both - take care to copy/paste it, that's an em-dash in there:

Code: [Select]

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:

Code: [Select]

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  ) and it works as a charm. Thanks again so much, Zybex!

[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  ) 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.

[HaWi]

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