Print

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

[realmassy]

Hello,
First of all thanks for this great software, I'm loving JRiver!
I need some help in tagging my classical music collections: I'm tagging the album using the composer work title (String Quartet No. 12, Op. 127 for example) and I'd like to copy the last bit of the title (Op. 127) to a new custom tag, for sorting purpose. I've already created the tag and I'm setting the value for my new music but I want to clean up the collection. Can someone help me?
Maybe I can do it with an expression? I basically need to get the last part of the album title, after the last ', '

Thanks in advance.

[JimH]

There is a topic on Expressions on our wiki.

This thread might also help:
http://yabb.jriver.com/interact/index.php?topic=45824.0

[realmassy]

Thanks for your quick reply Jim. I'm actually trying to use a regex to extract the value using the regex function...I'm not an expert so I'm struggling a bit! I'll post it on the classical music tagging thread.
In the meantime any help is appreciated :-)

[MrC]

How is the "last bit" characterized?  Is it the stuff that always follows the last comma?  Is it always Op. ###, or other?  If you can explain this, or show all the examples, I'll provide you with a regex.

[realmassy]

This is my attempt, definitely not pretty but seems to work:
If(Regex([Album], /#(.*),#/ , 0),RemoveLeft(RemoveLeft([Album], Length(Regex([Album], /#(.*),#/ , 1))), 2),)

Basically I'm checking if there's 'something' after the last comma, and in case remove it from the album tag (using the length), and then remove 2 more chars (", ")

The album title format (the last bit) is always ", <<catalog name>> <<catalog number>>"
Example:
", Op. 127"
", Op. 18 No. 2"
", BWV 82"
", K. 515"

Hope it's more clear now!

[MrC]

This will return the last part if that is all you want:

  ifelse(Regex([Name], /#, (.+)$#/), [R1])

and return nothing if there is no comma followed by a space.

[realmassy]

Cool, looks cleaner, I'll try and let you know. Cheers for now

[MrC]

Indeed.  You can use Regex() to pull out only the parts you need.

If that's all you want, you can use the simpler:

   Regex([Name], /#, (.+)$#/, 1)

without the conditional, since this will output either what was matched, or nothing at all.

[realmassy]

A bit late, sorry! The regex works perfectly, I've assigned it to a new field and then copied the value over the missing 'Opus Number' field that I had already setup. Thanks again for your help.