After reading all the posts so far about better support for classical music and Wer's tagging workflow thread, I decided to maybe, finally, tackle my inconsistent [Name] fields, as per the discussion a couple of months ago here
https://yabb.jriver.com/interact/index.php/topic,128127.msg888912.html#msg888912where I was interested in a view scheme that would help me weed out duplicate recordings (old rips vs. newer remasters, for example) of classical compositions.
I don't need to build [Composition] from [Name] as per the workflow thread mentioned above, since I tag from AMG using MCUtils, and [Composition], [Composer], and performers are about 99% consistent, with only the rare exception, but I would like to have a more foolproof (and quicker) way to find duplicate performances of compositions, plus just have [Name] be consistent.
I've filled [Name] using the basic "composition: movement" scheme already talked about in the two recent classical music threads. Therefore, because composition is consistent, everything to the left of the colon should be fine (and works without movements just get the composition as [Name]). Movement is another matter entirely because I wasn't and haven't been careful with it: basically, I've just taken what AMG has given me, which can vary a bit. For example, if there's an album that begins with Beethoven's Symphony No. 5, track 1 might come back from AMG as "1. Allegro con brio," "I. Allegro con brio," "Allegro con brio," or even something like "Movement I: Allegro con brio" or "No. 1: Allegro con brio."
Right now I'm trying to parse out the movement number on [Name]. For movements that were tagged with an arabic numeral plus a period (e.g., "1." or "4.") I created my first working Regex (!) for a quick fill-in of [Movement Number]:
=If(Regex([Name],/#:\s(\d)#/,1,0),[R1])
For Roman Numeraled movements, I just did a series of Find and Replaces. And for ones with "No.," I created another working Regex to fill in [Movement Number]:
=if(regex([name],/#:\sNo.\s(\d)#/,1,0),[R1])
And so on. Now I'm stumped on ones that have no number or regular text like "No." or "Movement," like simply "Allegro con brio." It would seem that I'd need to do something like an expand on [Composition] for a given album and performance and then somehow count the number of tracks of that composition in order (guided by the order of [Track #], if not the track numbers themselves), but I can't figure out how to do it, or if it's even possible without [Composition] being a relational field, if that's the right term. I did look at GroupCountQuery but couldn't figure out how to get a counter to work with it. Maybe some of the changes Matt is making at Wer's behest will help here? Or is there some other way I'm missing?