Sorry to be asking for so much help but I have tired to resolve things myself for hours and still fail.
Anyhow, I have read many threads on converting Arab to Roman and Roman to Arab, including Converting roman to arabic number and vice versa
From the fields %movement% and %movementtotal% I want to convert Arab numerals to Roman numbers and vice-versa. I create the names of my titles from the work & movement fields (%title% = %work%: %movement%. %movement name%) and would keep everything in roman up to 21 movements (a rule I read somewhere), but I found out that iTunes does not take roman numerals for their respective fields, so if I do not use arabic numbers, the movement number or total do not register.
For converting from roman to arab, I tried the following:
but any number over 9 created problems, because they were made up of the values before (e.g, "11" came back as "II" because it was made up of two "1"s. I could add leading zeros, which would solve the problem, but m4a does not allow leading zeros. I did find I could format the column using $num(%movement%,2), which would theoretically solve the problem of Arab to Roman, albeit not very elegantly, but it would not solve the problem that occurs when converting Roman back to Arab numbers.
When trying the same method to convert Arab numerals to Roman using
a value such a "II", will return "11" instead of "2".
There has to be a way to use scripts to either make each value discrete, where 1 and 11 are treated differently. I think it would involve some $iflonger function but I just can't figure it out. I have been trying a long time and thought maybe someone with much greater knowledge of Regular Expressions can help.
It would be greatly appreciated!!