AnsweredAssumed Answered

Using calculation to convert the Roman Numeral numbers

Question asked by Otto on May 26, 2009
Latest reply on May 26, 2009 by comment_1

Title

Using calculation to convert the Roman Numeral numbers

Post

 I made a search and found this script for converting roman numeral numbers to our US numbers.

How do I create a field with this code?

 

Roman (Text)
Number (Calculation, Number result)
= If (Position (Roman, "IX", 1), 9+Length (Roman)*10-20, If (Position (Roman, "IV", 1), 4+Length (Roman)*10-20, If (Right (Roman, 1) = "X", 10*Length (Roman), If (Right (Roman, 1)="V", 5+(Length (Roman)*10-10), If (Left (Roman, 3) = "XXX", 30+(Length (Roman)-3), If (Left (Roman, 2)="XX", 20+If (Position (Roman, "V", 1), 4, 0)+(Length (Roman)-2), If (Left (Roman, 1)="X", 11+If (Position (Roman, "V", 1), 4, 0)+(Length (Roman)-2), If (Left (Roman, 1)="V", 5, 1)+(Length (Roman)-1)))))))) *

Outcomes