GetAsArabic ( romanNumber )

GetAsArabic( romanNumber ) returns the arabic number equivalent for a roman number.

Average rating: 4.5 (27 votes) Log in to vote

Jeremy Bante
OshVay Systems, Inc.
http://www.oshvay.com

Sample input:

GetAsArabic( "MMXLVIII" )

Sample output:

2048

Function definition: (Copy & paste into FileMaker's Edit Custom Function window)

/*GetAsArabic( romanNumber ) returns the arabic number equivalent to romanNumber [text]. It will return correct values for both correctly and incorrectly formed roman numberals, and ignore all characters other than “i”, “v”, “x”, “l”, “c”, “d”, and “m”.*/

Let(
  roman = Lower( romanNumber); //normalize romanNumber to lowercase

  //tally values for letters
  (PatternCount( roman, "i")  * 1) +
  (PatternCount( roman, "v")  * 5) +
  (PatternCount( roman, "x")  * 10) +
  (PatternCount( roman, "l")  * 50) +
  (PatternCount( roman, "c")  * 100) +
  (PatternCount( roman, "d")  * 500) +
  (PatternCount( roman, "m")  * 1000) -


  //subtract for complex values
  (PatternCount( roman, "iv")  * 2) -  //(i+v)-iv=(1+5)-4=2
  (PatternCount( roman, "ix")  * 2) -  //(i+x)-ix=(1+10)-9=2
  (PatternCount( roman, "xl")  * 20) -  //(x+l)-xl=(10+50)-40=20
  (PatternCount( roman, "xc")  * 20) -  //(x+c)-xc=(10+100)-90=20
  (PatternCount( roman, "cd")  * 200) -  //(c+d)-cd=(100+500)-(400)=200
  (PatternCount( roman, "cm")  * 200)  //(c+m)-cm=(100+1000)-900=200
)  //end Let()

This list has two functions already for arabic-to-roman number conversion (RomanNumberal_1to4K(Parameter_number) by Brad Lowry, and RomanNumerals ( PageNumber ) by Don Wieland); this function performs the inverse operation. GetAsArabic( romanNumber ) returns the arabic number equivalent to romanNumber [a text string representing a roman numeral]. It will return correct values for both correctly and incorrectly formed roman numberals, and ignore all characters other than â��iâ��, â��vâ��, â��xâ��, â��lâ��, â��câ��, â��dâ��, and â��mâ��.

Comments

		Shah, Maaden, Saudi Arabia Aug 5, 2020
This is Shah, good job done, can you help me out here, I am looking for custom function for text field converted to arabic text in another field. I found only numeric converted to arabic text.

Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.

GetAsArabic ( romanNumber )

Comments

Support this website.

Support this website.