I have tried to figure this out, search this forum and the web but I can't figure it out. I want to use the "Variation 22" portion of my title "Variations and Fugue on a Theme by Handel, op. 24: XXIII. Variation 22" for the movementname.
So: Variations and Fugue on a Theme by Handel, op. 24: XXIII. Variation 22 = Variation 22
I could just use the cut command but since the amount of characters in front of "Variation" changes, it will not work. Also, the amount of words after Variation changes as well, and I would like to use all those characters so going from the right or left will not work. I basically want movement name to include all characters after the word "Variation" including the word "Variation" as well.
So, the same Reg Ex can make "Variations and Fugue on a Theme by Handel, op. 24: XX. Variation 19: Leggiero E Vivace" = "Variation 19: Leggiero E Vivace"
If this can be figured out, I could also use other portions of the title for movementtotal and movementnumber.
I suspect my problem is with the i in $mid(x,i,n). Any help would be greatly appreciated.
I tried using the $mid command but I could not get it to work.